Skip to content

Installation

Jump to bottom
Henrik edited this page Mar 27, 2020 · 38 revisions

Get Started

1. If you dont have an Api Key you need to apply for one as PRO member of Börsdata. (Link)  
2. Download Zip file from github and unpack to local folder  
3. Check if your Excel is installed as 32bit or 64bit. (Link)  
4. Install plugin in Excel. (See "Step by Step" below) 
5. Enter API Key in Borsdata Excel plugin  
6. Done

Is my Excel 32bit or 64bit?

1. Open Excel and go to File (1) -> Account (2).
2. "About Excel" (3) -> Check if you have 32-bit or 64-bit (4).

Check bit 32 64

Installation Step by step

Select File

Options

Addins Go

Addin Browse

Select file
32bit => BorsdataExcelPlugin-packed
64bit => BorsdataExcelPlugin64-packed

addin ok

Install done

Next you need to enter your API KEY under SETTINGS.
Now installation is ready!

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