Returns Reported Currency And Convert To Target Currency

The following sample SQL queries display the currency in which financials were reported and convert the data to a target currency

Enhancement Date: 5/25/2020

  • SourceMarket Intelligence
  • Data Packages Required
    Finl Premium CoreFinl Premium DetailFinl Premium StatementBase CompanyBase Data Item MasterBase Equity SecurityBase Exchange RatesBase Foundation Company DailyBase Security
  • Associated Datasets
    S&P Capital IQ Financials

Query Types

  • MSSQL
  • PostGreSQL
  • Snowflake