-
Notifications
You must be signed in to change notification settings - Fork 0
BD_INSTRUMENT_SEARCH
Help function to search for Instrument and InstId.
Will search for Global instruments if you have access.
| Syntax | Description | Required | Type | Sample |
|---|---|---|---|---|
| search | name of instrument | yes | string | "abb" |
| maxcount | return max hits. (default=1) | no | int | 10 |
| RemoveRange | clear old data | no | string range | "A2:C100" |
- If name is full match with search. Then always first in hitlist.
- If name starts with search. Then add first in hitlist.
- If name constains in search. Then add last in hitlist.
=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_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)