Sample Excel Pricing Sheets
Below you can find sample pricing sheets for publishing your prices to the embonds platform. Once downloaded you would need to Enable Macros in order to take full advantage of the functionality supplied by the pricing sheet.
Pricing Sheet Setup
To set up the pricing sheets for your environment you will need to follow these steps
- Open the pricing sheet and select Enable Macros
- If the Excel Add-in is not installed please follow the instructions under Excel Add-in on the left and install the Excel Add-in
- Proceed to the sheet named SetUp
- In the field Required Environment enter the environment you are connecting to. For the trading environment enter trade.embonds.com or if you are doing UAT or Demo please select uat.embonds.com or demo.embonds.com respectively.
- Click on Set Required Environment and observe the messages under Current Environment and EMBonds Addin Path. You must ensure that the Current Environment is the same as the Desired Environment and the path of the embonds Excel Addin is displayed. If the Add-in is not installed you will be alerted to the fact.
- If you have been supplied with a Username and Password, login to the desired embonds environment
- Go to Settings
- Select Excel API and click on Generate Token
- Copy the token and paste it into cell B16 in the SetUp worksheet in the Excel document.
- Click on Test Installation button to check if the installation was successful