Find Jobs
Hire Freelancers

Design and create an Excel spread sheet to be used as an API for Interactive Brokers

$30-250 USD

In Progress
Posted over 10 years ago

$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: 640.21/640.34) (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

About the project

3 proposals
Remote project
Active 10 yrs ago

Looking to make some money?

Benefits of bidding on Freelancer

Set your budget and timeframe
Get paid for your work
Outline your proposal
It's free to sign up and bid on jobs
3 freelancers are bidding on average $117 USD for this job
User Avatar
Hi, I have more than 14 years of exp and I am expert in this kind of work. I have completed more than 200 projects. Please look at the feedback left by my employer to know more about my work. Waiting for your positive response. Thanks.
$166 USD in 10 days
4.9 (121 reviews)
6.3
6.3
User Avatar
I can help. I am an Excel / VBA coder pro with over ten years experience in developing automated, Excel based applications. I have specific experience in modifying Interactive Brokers VBA code. I integrated their platform with my client's specific trading algorithm, with Yahoo Finance historical price updater and an email alert system. (I can provide a sample on request). My bid assumes that all you require is the addition of a Summary Order tab which processes the Basic Orders tab, provides additional computational columns and sub-totals asset classes. I have the expertise and the experience to successfully deliver your project. Your comments and questions are most welcomed. Regards Zenon H
$110 USD in 3 days
4.9 (32 reviews)
5.6
5.6

About the client

Flag of UNITED KINGDOM
neston, United Kingdom
5.0
5
Payment method verified
Member since Jul 21, 2010

Client Verification

Thanks! We’ve emailed you a link to claim your free credit.
Something went wrong while sending your email. Please try again.
Registered Users Total Jobs Posted
Freelancer ® is a registered Trademark of Freelancer Technology Pty Limited (ACN 142 189 759)
Copyright © 2024 Freelancer Technology Pty Limited (ACN 142 189 759)
Loading preview
Permission granted for Geolocation.
Your login session has expired and you have been logged out. Please log in again.