Statements, calendars, and screener metrics
NEW statement functions
income,balancesheetandcashflowwith new line items and significantly improved consolidation and standardisation. Deprecated statement functions remain active for backward compatibility.NEW
iposadded as Financial Calendar type for upcoming and historical IPOs.NEW option
calYearfor statements, growth, ratios, revenue segmentation and others allowing search by calendar year rather than company financial year.NEW option
padfor statements, growth, ratios, revenue segmentation and others to left and/or right pad output data with blank columns for missing periods to maintain consistent output between companies.NEW option
includeWeekendsforhistoricalfunction to include weekend dates when pulling data for crypto and forex/commodities.Metrics added to stock screener:
ipoDate,avgVolumeandprice. All included as basic filters and allowing sorting.Metrics added to
dividendsFinancial Calendar:frequencyandyield.Metric added to
prePostMarket:volume.Metric added to
insiders:directOrIndirect.Metrics added to
peers:name,priceandmarketCap.Metric added to
SF_NEWS():publisher.Statement functions now support a range of years for TTM data to output TTM data per quarter side-by-side for multiple years. E.g.,
SF("AAPL", "incomeTTM", "all", "2019-2022")will return TTM income statements for each quarter from 2019 to 2022.Statement functions support sorting by
YYYY-MMfor quarterly data when usingcalYearoption. E.g.SF("AAPL", "incomeQ", "all", "2022-09", "calYear")will return the quarterly statement released in September 2022.estimatesnow defaults to next/upcoming year when year parameter is omitted.priceTargetsfunctions now acceptsYYYY,YYYY-MMandYYYY-MM-DDformats for date parameter not justlastXMonths.insiderStatsname changes for clarity. Old naming conventions backward compatible.cikadded.Significant improvements to caching, performance and speed across all functions.
Breaking:
No longer supporting inter-day periods for Technical Analysis time-series (
1week,1month,1year).Removal of metrics
releaseTimeandfiscalYearEndfromearningsfunction.