Skip to content

Installation

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

Get Started

Borsdata Excel Plugin is a file you need to manualy install into Excel.
You need to know if you have excel version 32bit or 64bit. How to check this is shown below.

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

Follow the steps to install the Borsdata Excel Plugin into Excel.

Select File
Open Excel and go to File.
Options

Addins Go

Addin Browse

Select file
Open the folder where you unzipped the Borsdata excel plugin.
There is two files in the folder. Select the file that match you Excel version.
32bit => BorsdataExcelPlugin-packed
64bit => BorsdataExcelPlugin64-packed

addin ok

Install done

Finally 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