Excel API
© 2022 BidFX Systems Ltd. 3 of 32
About BidFX .................................................................................................................................. 4
Introduction ................................................................................................................................. 4
Related APIs ................................................................................................................................. 4
Programming Language .............................................................................................................. 5
Installation ................................................................................................................................... 5
Guides on Usage .......................................................................................................................... 5
Serial Keys and Logging in...................................................................................................... 5
Creating a Subject ID .............................................................................................................. 7
Streaming Subject ID .......................................................................................................... 7
Quote Subject ID ................................................................................................................. 8
Depth Subject ID ................................................................................................................. 9
Indicative Pricing Subject ID ........................................................................................... 10
Valid Tenors ....................................................................................................................... 10
Getting a price field .............................................................................................................. 11
Direct RTD Calls ................................................................................................................. 12
Price Field Names.................................................................................................................. 13
Formatting Time Fields ........................................................................................................ 15
Example .................................................................................................................................. 16
LP Names ............................................................................................................................... 16
Trading ........................................................................................................................................ 20
Enable Trading ....................................................................................................................... 20
Staging An Order ................................................................................................................... 20
Trading Ticket .................................................................................................................... 20
Functions ........................................................................................................................... 21
Example: ........................................................................................................................ 22
FX Limit orders .................................................................................................................. 23
Order Parameters ............................................................................................................. 24
FX Orders....................................................................................................................... 24
Futures Orders ............................................................................................................. 26
Creating Custom Allocation Templates ......................................................................... 27
Getting Settlement and Fixing Dates ...................................................................................... 27
BXSETTLEMENTDATE ............................................................................................................. 28
BXFIXINGDATE ....................................................................................................................... 28
Points of Presence ..................................................................................................................... 28
Production ............................................................................................................................. 28
Test environments ................................................................................................................ 29
Logging ........................................................................................................................................ 29
Sharing Spreadsheets ............................................................................................................... 29