Skip to content

BD_REPORT_YEAR

Jump to bottom
Henrik edited this page Mar 26, 2020 · 7 revisions

BD_REPORT_YEAR(InstId; Standing; Fixed)

Get Yearly Report data.
This is reports with Period=5.

Syntax Description Required Type Sample
InstId Instrument Id yes number 3
Standing Show table as flatt or standing. 0=default no number 0, 1
Fixed Return Fixed number of history data. no number 1 to 100

Sample

=BD_REPORT_YEAR(3)

Return table of all reports for ABB

=BD_REPORT_YEAR(3;;5)

Return table of last 5 reports for ABB. Note: Standing is skipped and uses default value 0.

=BD_REPORT_YEAR(3;1;5)

Return Standing table of last 5 reports for ABB.

Home
Installation
=BD_INSTRUMENTS()
=BD_INSTRUMENT_DESCRIPTION(InstId)
=BD_INSTRUMENTS_GLOBAL() =BD_INSTRUMENTSEARCH()
=BD_KPI_SUMMARY()
=BD_STOCKPRICE()
=BD_STOCKPRICE_DATE()
=BD_STOCKPRICE_GLOBAL_DATE()
=BD_STOCKPRICE_LAST() =BD_STOCKPRICE_GLOBAL_LAST() =BD_REPORT_QUARTER()
=BD_REPORT_R12()
=BD_REPORT_YEAR()
=BD_HISTORY_KPI()
=BD_SCREENER_KPI()
=BD_SCREENER_GLOBAL_KPI()
=BD_REPORT_CALENDAR(InstId)
=BD_DIVIDEND_CALENDAR(InstId)
=BD_HOLDINGS_INSIDER(InstId)
=BD_HOLDINGS_SHORTS()
=BD_HOLDINGS_BUYBACK(InstId)

Excel-Buttons
Common Errors
Remove Range

Clone this wiki locally