Skip to content

BD_REPORT_R12

Henrik edited this page Oct 30, 2024 · 7 revisions

BD_REPORT_R12(InstId; Standing; Fixed; RemoveRange)

Get Rolling 12month (R12) Report data.
This is reports with Period 1 to 4.

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_R12(3)

Return table of all reports for ABB

=BD_REPORT_R12(3;;5)

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

=BD_REPORT_R12(3;1;5)

Return Standing table of last 5 reports for ABB.

Sample Global

Same calls as Nordic

=BD_REPORT_R12(10214)

Return table of all reports for APPLE