Skip to content

BD_REPORT_YEAR

Henrik edited this page Oct 30, 2024 · 7 revisions

BD_REPORT_YEAR(InstId; Standing; Fixed; RemoveRange)

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
RemoveRange clear old data no string range "A2:C100"
Original Return original report currency, 0=default no number 0,1

RemoveRange

Sample Nordic

=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.

Sample Global

Same calls as Nordic

=BD_REPORT_YEAR(10214)

Return table of all reports for APPLE