Find Jobs
Hire Freelancers

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

$30-250 USD

En curso
Publicado hace más de 10 años

$30-250 USD

Pagado a la entrega
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
ID del proyecto: 5237498

Información sobre el proyecto

3 propuestas
Proyecto remoto
Activo hace 10 años

¿Buscas ganar dinero?

Beneficios de presentar ofertas en Freelancer

Fija tu plazo y presupuesto
Cobra por tu trabajo
Describe tu propuesta
Es gratis registrarse y presentar ofertas en los trabajos
3 freelancers están ofertando un promedio de $117 USD por este trabajo
Avatar del usuario
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 en 10 días
4,9 (121 comentarios)
6,3
6,3
Avatar del usuario
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 en 3 días
4,9 (32 comentarios)
5,6
5,6

Sobre este cliente

Bandera de UNITED KINGDOM
neston, United Kingdom
5,0
5
Forma de pago verificada
Miembro desde jul 21, 2010

Verificación del cliente

¡Gracias! Te hemos enviado un enlace para reclamar tu crédito gratuito.
Algo salió mal al enviar tu correo electrónico. Por favor, intenta de nuevo.
Usuarios registrados Total de empleos publicados
Freelancer ® is a registered Trademark of Freelancer Technology Pty Limited (ACN 142 189 759)
Copyright © 2024 Freelancer Technology Pty Limited (ACN 142 189 759)
Cargando visualización previa
Permiso concedido para Geolocalización.
Tu sesión de acceso ha expirado y has sido desconectado. Por favor, inica sesión nuevamente.