Financial Data Provider Integrations

Overview

This skill provides Excel formula syntax for major financial data providers. Only pull data when the user explicitly requests a specific provider.

Each provider has its own markdown file with complete documentation:

• bloomberg.md - BDP, BDH, BDS formulas
• factset.md - FDS formulas with FF_, FG_, FE_ prefixes
• capiq.md - CIQ formulas with IQ_ variables
• refinitiv.md - RDP.Data, TR, DSGRID formulas
• morningstar.md - MSDP, MSTS, MSHOLDING formulas
• pitchbook.md - PB, PBMATCH formulas for private markets
• preqin.md - Alternative assets data (PE, VC, Real Estate)
• alphasense.md - TEGUS formulas and AI-powered research
• earnings_transcripts.md - Transcript access across providers

Quick Reference

Provider	Formula	Ticker Format	Example
Bloomberg	=BDP(), =BDH(), =BDS()	AAPL US Equity	=BDP("AAPL US Equity","PX_LAST")
FactSet	=FDS()	AAPL-US	=FDS("AAPL-US","FF_SALES(ANN,0Y)")
Capital IQ	=CIQ()	AAPL	=CIQ("AAPL","IQ_TOTAL_REV",IQ_FY)
Refinitiv	=RDP.Data(), =TR()	AAPL.O	=TR("AAPL.O","CF_LAST")
Morningstar	=MSDP(), =MSTS()	VFIAX or NAS:AAPL	=MSDP("VFIAX","MorningstarRating")
PitchBook	=PB()	Name or PBID	=PB("SpaceX","PostMoneyValuation")
AlphaSense	=TEGUS.CD()	AAPL_US	=TEGUS.CD("AAPL_US","MO_RIS_REV","FY-2023")

Workflow

1. Identify provider - User must explicitly mention which provider to use
2. Read the provider's markdown file - Each has complete syntax reference
3. Write formulas - Use cell references for tickers when possible
4. Verify outputs - Gut check values make intuitive sense
5. Handle errors - Check syntax if formulas return errors

Common Data Points by Provider

Bloomberg

• Price: PX_LAST, PX_VOLUME, CUR_MKT_CAP
• Fundamentals: SALES_REV_TURN, EBITDA, NET_INCOME, IS_EPS
• Ratios: PE_RATIO, EV_TO_T12M_EBITDA, RETURN_COM_EQY

FactSet

• Pricing: FG_PRICE, FG_MKT_VAL
• Fundamentals: FF_SALES, FF_EBITDA, FF_NET_INCOME, FF_EPS
• Estimates: FE_ESTIMATE(EPS,MEAN,ANN,+1)

Capital IQ

• Core: IQ_TOTAL_REV, IQ_EBITDA, IQ_NI, IQ_DILUT_EPS_INCL
• Market: IQ_MARKETCAP, IQ_TEV
• Periods: IQ_FY, IQ_LTM, or numeric codes (1000=FY, 999=prior FY)

Refinitiv

• Real-time: CF_LAST, CF_BID, CF_ASK
• Historical: TR.Revenue, TR.EBITDA, TR.NetIncome
• Datastream: P price, MV market value, WC01001 revenue

Morningstar

• Fund: MorningstarRating, ExpenseRatio, NAV_daily
• Returns: ReturnY1, ReturnY3, ReturnY5
• Stock: FairValue, EconomicMoat

PitchBook

• Valuation: PostMoneyValuation, PreMoneyValuation
• Funding: TotalFundingRaised, LastFundingAmount, LastFundingType

AlphaSense (Tegus)

• Income: MO_RIS_REV, MO_RIS_EBITDA, MO_RIS_NET_INC
• Balance: MO_RBS_TOTAL_ASSETS, MO_RBS_TOTAL_DEBT
• Cash Flow: MO_RCF_CFO, MO_RCF_FCF

Best Practices

1. Always verify - Formulas should not return errors
2. Gut check values - Numbers should make intuitive sense
3. Use cell references - For tickers and periods, not hardcoded values
4. Be aware of limits - Bloomberg and others have monthly download caps
5. Check units - Know if values are in thousands, millions, or actual

Period Notation Summary

Provider	Current FY	Prior FY	LTM	Quarter
Bloomberg	[FY0]	[FY-1]	[TTM]	[FQ0]
FactSet	ANN,0Y	ANN,-1Y	LTM	QTR,0Q
Capital IQ	IQ_FY or 1000	999	IQ_LTM	IQ_FQ or 500
Refinitiv	Period=FY0	Period=FY-1	Period=LTM	Period=FQ0
AlphaSense	FY-2023	FY-2022	LTM	Q1-2024

Error Handling

If formulas return errors:

1. Check ticker format matches provider's expected format
2. Verify field/variable name spelling
3. Check period syntax
4. Try refreshing the add-in
5. Confirm data coverage for that security