Find Jobs
Hire Freelancers

Convert trading system - excel to Python for OANDA's REST v20 API

$30-250 USD

Cancelled
Posted about 6 years ago

$30-250 USD

Paid on delivery
I have a simple trading strategy built in excel that needs to be converted to Python 2.7, that will run on OANDA's REST v20 API. Brief details - the strategy uses very simple excel logic - IF statements, vlookup's, etc. There is no VBA. - the workbook uses 3 spreadsheets and is designed for one product. In the converted code, I need this changed to work on a basket of securities, rather than just one. - the workbook is written as a backtest. In the converted code, I need to be able to perform backtests and run it live within the OANDA practice and live trading environments. - As a reference, the entire workbook is only 15MB when containing 5 years of historical intraday data. - I have a strong understanding of excel and can explain in detail all logic to assist in the conversion process.
Project ID: 16777858

About the project

13 proposals
Remote project
Active 6 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
Awarded to:
User Avatar
I have extensive experience in python and financial markets and would love to help you out on this project. I currently work as a consultant for a long/short equity hedge fund part/time in Palo Alto, CA and have a masters in financial mathematics/engineering at Santa Clara University. I think I would be of great help to you. My credentials are below: * Responsible for creating proprietary quantitative models and algorithmic trading strategies for long/short equity optimization models with specific risk and return parameters specified by the investor profile, utilizing machine/deep learning, along with Q reinforcement learning agents. •Created predictive vectorized/event-based machine learning models utilizing multivariate/logistic regression, lasso/ridge regression, linear/quadratic discriminant analysis, decision trees, K neighbors, Naive Bayes, random forest, support vector machine, Adaptiveboost, GradientBoost, XGB, and portfolio optimization to maximize return and minimize volatility for various investor risk profiles. •Responsible for deep learning modeling using recurrent neural networks, Tensorflow, nltk, sentiment analyzer, Keras LSTM, and convolutional neural networks, in attempt to predict specific asset class forecasted prices through stocks, forex, bonds, futures, ETFs, and other derivatives. •Designed a proprietary machine/deep learning long/short intraday algorithm utilizing the Interactive Brokers API, IB_Insync python library.
$132 USD in 3 days
5.0 (8 reviews)
4.1
4.1
13 freelancers are bidding on average $176 USD for this job
User Avatar
Greetings, I have experience with python and automated trading. I can link with V20 and give you functionality of the excel workbook. Regards
$250 USD in 6 days
4.4 (11 reviews)
3.8
3.8
User Avatar
Hello, I'd be happy to do this project since I have experience with both python and trading bots. I have built python codes utilizing exchanges' APIs to automate trading strategies, it was mostly for cryptocurrency exchanges, but the same concepts should apply to any type of trading or APIs. I have 2 hours available everyday that I'm willing to dedicate to this project, I indicated one week as a deadline for this project but it strongly depends on your requirements. Please PM me and we could discuss the details further
$250 USD in 7 days
4.2 (8 reviews)
3.4
3.4
User Avatar
A proposal has not yet been provided
$144 USD in 2 days
0.0 (0 reviews)
0.0
0.0
User Avatar
Hi, I have 5 years excel data in investment portfolio app. app shows Projected wealth on calulation and it also shows 5y, 2y, 1y, 6months chart for different Share markets. I can do your job in mentioned technology. Please come over chat for detailed discussion Thanks Ravi
$388 USD in 7 days
0.0 (0 reviews)
0.0
0.0
User Avatar
Hey I have a good exp
$100 USD in 3 days
0.0 (0 reviews)
0.0
0.0
User Avatar
Hey, I am an expert in python. I have done various projects like this before in python. Some of my previous projects are automating alpha testing on Websim platform, collecting and analyzing stream data of trade on BSE and NSE.
$100 USD in 3 days
0.0 (0 reviews)
0.8
0.8
User Avatar
What's drawn my attention to your offer are the two scripting languages: Excel (VBA) & Python. I'm a Software Test Engineer, with more than 4 years experience in Automation & Testing for Automotive industry. In both VBA & Python I've created & manipulated Excel files via functions/macros. Basically what I can do for you is create a Python 2.7 generator for your simple Excel file containg 3 sheets, a copy from the original one, that will work for more securities (I see them as external callers on the Excel file - to be discussed any other details on this subject). A note is that no one can write an Excel file as any kind of test, maybe you were thinking of the Python file that contains the Excel file creation, security & testing parts, all combined. In my vision, this will be the workflow: with Python we'll create a copy of the existing Excel, then we'll call more security functions on it (or we'll create new ones) and also some backtests and at the end the .py file will pe uploaded on OANDA. Look forward to hearing from you!
$260 USD in 2 days
0.0 (0 reviews)
0.0
0.0

About the client

Flag of THAILAND
Wynyard, Thailand
5.0
6
Payment method verified
Member since Apr 25, 2018

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.