I am looking for an experienced professional who can assist me in extracting economic forecast data from Bloomberg Terminal. The project involves retrieving historical data, individual forecasts, and calculating standard deviation.

I am looking for an experienced professional who can assist me in extracting economic forecast data from Bloomberg Terminal. The project involves retrieving historical data, individual forecasts, and calculating standard deviations using Bloomberg functions and templates.

Project Details:

Data Extraction:

Economic Forecasts:
US Real GDP YoY
US Inflation Rate
US Unemployment Rate
US Federal Funds Rate
US Consumer Price Index (CPI)
US Producer Price Index (PPI)
US Non-Farm Payrolls
US Industrial Production
US Retail Sales
US Trade Balance
Historical data should be retrieved for the longest period available.
Standard Deviation Calculation:

Utilize the XLTP XCEF template to pull individual forecasts by brokers.
Create distribution charts and calculate standard deviations of these forecasts.
Ticker Identification and Data Retrieval:

Use the ECFC function to find top contributors and corresponding broker codes.
Extract individual forecast data using formulas like =BDH("ECGDUS 24 ABN Index","PX_LAST","20240101","").
Example tickers for data extraction: ECGDUS 24 ABN Index, ECGDUS 24 CITI Index, etc.
S&P 500 Data:

Retrieve 12-month price targets for S&P 500 using the BEST_TARGET_PRICE field.
Access historical individual estimates through SPX Index ANR.
Skills Required:

Proficiency with Bloomberg Terminal and its functions.
Strong understanding of financial data and economic indicators.
Advanced Excel skills, including formula creation and data analysis.