API

6 articles

Excel PowerQuery/PowerBI & New Columns

Molecule adds new columns to our API from time to time. (We do not remove or alter columns, generally, to avoid creating compatibility issues.) When columns are added, PowerQuery and/or PowerBI somet…

Updated 2 months ago

How to Update Your Spreadsheet's Molecule Credentials

If you need to update a spreadsheet connected to Molecule's API with new credentials, follow the instructions below. Method 1 The easiest method is to update an existing spreadsheet after your Molecu…

Updated 2 months ago

How to Upload Market Data via API

Market data is relatively easy to get into Molecule. Some of our customers upload market data via API. API, Version 2 As of early 2019, Molecule has a new upload API for market data. For more informa…

Updated 2 months ago

How to Generate an API Token

Follow the instructions below to generate a token to access Molecule's API. In Molecule, click SETTINGS on the left-hand navigation bar, then click API KEYS. If you don't have access to this menu, pl…

Updated 2 months ago

API Documentation

Molecule's API documentation is available here. To get the access code: Go to Reports/Extracts in the Molecule app. The password is listed at the top of the screen. Email our Customer Success team to…

Updated 2 months ago

How to Connect Your Spreadsheet

If you use spreadsheets to monitor trading activity, you can connect them to Molecule via our API. This will save a lot of time as it removes the tedium of updating your file and automates the proces…

Updated 2 months ago