API & Data Integration
API Resources
API Documentaion
Getting Started with Molecule API
How to Generate an API Token
Assets
How to Create a New Asset
Importing Asset Data
Bigbang
Getting Started with Bigbang
Data Integrations
Downloading Raw Data
Excel PowerQuery/PowerBI & New Columns
How to Connect Your Spreadsheet
How to Update Your Spreadsheet's Molecule Credentials
Market Data
How to Import Market Data (Curves)
How to Import Market Data (Surfaces)
How to Upload Market Data via API
Core Topics
Approaches
Managing PPAs
Options
Trades: Calculating Position and P&L
US Physical Natural Gas
Valuation & Relevant Products
Concepts
As-Of Date
Mark Levels
Origins
Tenor
Models
Assets Stack
Inventory & Tickets Stack
Stacks: Main Models in Molecule
Trades Stack
Features
Account Settings
.Account Settings Overview
Access Control - Users and Groups
Calendars
Custom Fields
Fee Maintenance
ICE + CME Adapters
Permissions
Workflows
Back Office
Actualization
Agreements
How to Create a New Counterparty
How to Reconcile Molecule with your FCM Statements
Risk Metrics
VaR (Value at Risk) Calculation
Specialized Features
Cascading
Curve Builder
Customer Test Environments
Decay
Exposures
Mo - AI Data Assistant
P&Sing
Ticks
Trades
Trade Amendments
How to Amend a Trade
How to Clone a Trade
How to Split a Trade
How to Transfer a Trade
How to Void a Trade
Trade Entry/Edit
How to Book a Trade via NLP
How to Enter Broker Information
How to Enter Fee Information
How to Enter a Trade
How to Transfer a Position
Park and Loan Trade Entry
Trade Workflows
Trade Lifecycle Attachments
Trade Locking
Trades Screen
5 Things you Can Do on the Trades Screen
How to Bulk Update Tags
How to Group/Ungroup Trades
How to Import Trades
How to Lock/Unlock Trades
Trade IDs
Valuations Screen
How to Pivot and Group on the Valuations Screen
How to Use the Valuations Screen
Getting Help
Contact Information
How to Request New Products
Molecule Feature/Enhancement Request Guidelines
Valuation
Dynamic Volume Trades
Intramonth Trades
Marking Spreads
Option Models
Pricing Formulas
Valuation Outputs
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 1 year ago by Sameer Soleja
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 years ago
Connect Excel to Molecule for automated trading data updates via API integration
Updated 2 months 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…
Powered by HelpDocs (opens in a new tab)
