Design and create an Excel spread sheet to be used as an API for Interactive Brokers
$30-250 USD
Paid on delivery
Hello,
I'm looking for someone to work in excel and build/modify an API (example attached) that includes the information detailed below. It must have the functionality to display all current open positions automatically and include the following data/columns. The information to calculate this is currently pushed into the API anyway (API example is attached).
Ticker symbol (for example: AAPL) (standard macro from the attached example)
Description (for example: Apple) (standard macro from the attached example)
Expiry (for example: 2013/07/19) (standard macro from the attached example)
Contract type (for example: 640 Put) (standard macro from the attached example)
Position (for example = –1 (short one contract)) (standard macro from the attached example)
Average price (for example 0.32) (standard macro from the attached example)
Bid/Ask (for example: [url removed, login to view]) (standard macro from the attached example)
Spread of bid/ask (for example: 0.13 Cents) –> formula = ask price minus bid price = spread value. (non-standard macro needs coding)
Mid-price of spread -> formula = ask price plus bid price divided by 2 = mid-price. (non-standard macro needs coding)
P/L based on Mid price (formula for short positions = Average price minus current mid-price) (formula for long positions = Current mid-price minus Average price )
Credit received (formula = average price of credits minus average price of debits = total credit )
Current % of maximum profit (formula = current credit divided by total credit *100) current credit is calculated by using the Mid price of spread.
All the above columns need to group each asset separately and have a sub total P/L of each asset.
Please feel free to ask any questions
Project ID: #5237498