Skip to content

BD_INSTRUMENT_SEARCH

Jump to bottom
Henrik edited this page Apr 17, 2020 · 10 revisions

BD_INSTRUMENT_SEARCH(search; maxcount)

Help function to search for Instrument and InstId

Syntax Description Required Type Sample
search name of instrument yes string "abb"
maxcount return max hits. (default=1) no int 10

Sample

=BD_INSTRUMENT_SEARCH("abb")

Return first instrument starts with "abb".
If maxcount is not added, only first hit is returned (default=1).

=BD_INSTRUMENT_SEARCH("ab";10)

Return top 10 Instrument with "ab" in name

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