Skip to content

Excel Buttons

Jump to bottom
Henrik edited this page Mar 31, 2020 · 10 revisions

excel buttons

1. Refresh button

This button calls Api and reload all data on the active Spreadsheet.
If you have many functions this may take some time.
Refresh only reload Börsdata Functions. Any other Excel functions is not reloaded.If you have seveal Spreadsheet with Borsdata Functions, then you need to run Refresh on each Spreadsheet.

If you want all full refresh of all functions in all Spreadsheet you can use the excel command CTRL+ALT+F9.

2. Settings menu

Settings

Api Key

Here you enter your Börsdata API KEY. This is saved localy on you computer.
If you dont have an API KEY you need to Apply for it on Börsdata MyPage.

Use Dynamic Array

Return data to excel as Dynamic Array or write data to each cell.
Dynamic array can only be used by lastest excel versions.

English language

Return data with English or Swedish translation.

Error logfiles

We save a new logfile for every day.
If you have error then check in last log file if you can see whats the problem.
If you cant fix the problem then email last logfile to Börsdata for support.

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