Skip to content

Installation

Jump to bottom
Henrik edited this page Apr 26, 2022 · 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.
  2. Download Zip file from github and unpack to local folder.
  3. Check if your Excel is installed as 32bit or 64bit.
  4. Install plugin in Excel. (See "Step by Step" below)
    4.1. Important! Add the folder where you have the .xll file to 'Trusted Locations' 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

In Excel 2010 you go to "File"-> "Help" -> Check Version (32-bit or 64-bit)

Add the .xll file folder to 'Trusted Locations' in Excel.

You need to tell Excel that the .xll folder is trusted before you install the .xll file.

  1. Excel Options (Alternativ)
  2. Securitycenter (Säkerhetscenter) -> Settings for securitycenter
  3. Trusted Locations-> Add new Location
  4. Browse.. -> Select the folder
    Done

IMPORTANT! Make sure that Add-ins => Reqire ApplicationsAdd-ins to be signed by Trusted Publisher is DISABLED.

Trust Location 1
Trust Location 2
Trust Location 3

Installation Step by step

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

  1. Download zip file from github.
    Download

Chrome and Firefox can give a warning that file is not normaly used. Ignore this warning. Keep file.
ChromeWarning

  1. When Zip file is downloaded you need to UnZip the Zip file into a new folder.
    Right-click on the Zip file and select "Extract All".
    How to unzip
    Now you have a new folder with two .xll files that can be used by Excel.

  2. Important! Add the folder where you have the .xll file to 'Trusted Locations' in Excel. (See "Step by Step")

  3. Open Excel and go to File.
    Select File

  4. Option
    Options

  5. Add-Ins -> Go..
    Addins Go

  6. Browse...
    Addin Browse

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

  8. Make sure Börsdata Excel is shown in Add-Ins avaible list.
    addin ok
    Press Ok.

  9. Now you should see the Börsdata Ribbon in Excel.
    Ribbon

  10. Finally you need to enter your API KEY under SETTINGS.
    ApiKey

  11. Now installation is ready!

Upgrade to new version of Excel Plugin

Download new zip from Github and replace your existing local .xll file.
Restart Excel and you should have the new version automaticly loaded into excel.

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