API & Data Integration
API Resources
How to Generate an API Token
API Documentaion
Getting Started with Molecule API
Assets
Importing Asset Data
Bigbang
Getting Started with Bigbang
Data Integrations
Downloading Raw Data
How to Connect Your Spreadsheet
How to Update Your Spreadsheet's Molecule Credentials
Excel PowerQuery/PowerBI & New Columns
Market Data
How to Import Market Data (Surfaces)
How to Upload Market Data via API
How to Import Market Data (Curves)
Core Topics
Approaches
Options
Trades: Calculating Position and P&L
Valuation & Relevant Products
US Physical Natural Gas
Managing PPAs
Concepts
As-Of Date
Tenor
Origins
Mark Levels
Models
Assets Stack
Inventory & Tickets Stack
Trades Stack
Stacks: Main Models in Molecule
Features
Account & Settings
Fee Maintenance
Calendars
How to Add Users
Permissions
Account Settings
Back Office
How to Reconcile Molecule with your FCM Statements
How to Create a New Counterparty
Agreements
Actualization
Cascading & Decay
Cascading
Decay
Specialized Features
P&Sing
Ticks
Exposures
Customer Test Environments
Curve Builder
Trades
Trade Amendments
How to Amend a Trade
How to Transfer a Trade
How to Void a Trade
How to Clone a Trade
How to Split a Trade
Trade Entry/Edit
Park and Loan Trade Entry
How to Enter a Trade
How to Transfer a Position
How to Book a Trade via NLP
How to Enter Broker Information
How to Enter Fee Information
Trade Workflows
Trade Locking
Trade Lifecycle Attachments
Trades Screen
How to Group/Ungroup Trades
Trade IDs
5 Things you Can Do on the Trades Screen
How to Import Trades
How to Bulk Update Tags
How to Lock/Unlock Trades
Valuations Screen
How to Pivot and Group on the Valuations Screen
How to Use the Valuations Screen
Getting Help
Molecule Feature/Enhancement Request Guidelines
How to Request New Products
Contact Information
Valuation
Pricing Formulas
Valuation Outputs
Marking Spreads
Option Models
Intramonth Trades
Dynamic Volume Trades
All Categories > API & Data Integration > Data Integrations
4 articles
Sometimes, you'd rather not use the Valuations Screen or custom reports -- and just download CSV data straight from Molecule. To do this: Go to Reports > Extracts. Choose the reporting date on the to…
Updated 11 months ago by Sameer Soleja
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 1 month ago
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 1 year ago
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…
Powered by HelpDocs (opens in a new tab)