Find Jobs
Hire Freelancers

Backtest a stock market trading strategy using Google Spreadsheets

$10-30 USD

Closed
Posted over 7 years ago

$10-30 USD

Paid on delivery
I need someone to backtest the following trading strategy in google drive spreadsheets (which is free to use, basically cloud excel with a few less functions.) This will take some stock market knowledge, and sorting/inputting a lot of data (though I'm sure a decent amount can be copy/pasted.) Strategy: Short Term Reversal Core strategy: If a stock has relatively low (high) returns over the past month or week, it can earn positive (negative) abnormal returns in the following month or week Approach 1: Standard reversal strategy using the 500 and 100 largest cap U.S. stocks. More specifically, a reversal investment strategy that is long in the 20 percent stocks with the lowest one-week returns and short in the 20 percent with the highest returns Approach 2: A slightly more sophisticated approach (in addition to approach 1) that waits to sell (buy back) stocks until they are ranked among the 50 percent of winner (loser) stocks ranked on past return. These stocks are then replaced by the stocks with the lowest (highest) past-week return at that time and not yet included in the portfolio. Your job: For EACH approach determine the basis points profit or loss per week overall and for each individual stock that would be traded in each approach. Show the entry and exit points for each qualifying stock based on the stock's open or closing prices. Also backtest approach 1 and 2's weekly profits for the last year. Add/change any tweaks to the strategy. This will require the freelancer to find a site with data for the weekly returns of the stocks. Yahoo finance has opening/closing data, but if you find something better that's fine as well.
Project ID: 11790132

About the project

15 proposals
Remote project
Active 7 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
15 freelancers are bidding on average $353 USD for this job
User Avatar
Hello. 30 % of employers hiring me once hired me again. I have experience in the same. I CAN do this job, and do it well!
$170 USD in 1 day
5.0 (119 reviews)
6.6
6.6
User Avatar
Dear Valued Employer, I can add value to your project, by suggesting new ideas. I am fast and reliable. For further understanding why I am the right firm for your project, kindly check my profile, reviews, rating and portfolio. With over 8 years of cross-functional experience, and helping clients world wide with diversify team, I provide genuine and innovative solutions as per your circumstances and requirements. I am MBA-Finance, M.A-Economics, and Qualified Chartered Accountant. If you feel to discuss more before you award me the project, you can send me the message. Kind regards, Rakesh
$500 USD in 1 day
4.7 (45 reviews)
6.0
6.0
User Avatar
You rs is an interesting project because I occasionally trade in the stock market. It is always a good thing to create a strategy and follow it. Please message me if you are interested, we can certainly take the project forward
$25 USD in 1 day
4.6 (63 reviews)
5.4
5.4
User Avatar
Hi, I can take 100% confidently your project. I can give high quality service from others. I am expert about it. You can see my full profile and feedback to check the experience. I available online any time.
$25 USD in 1 day
4.9 (26 reviews)
4.4
4.4
User Avatar
Hi I have read out all the description given in your project and I am fully capable to deliver this Project with 100% accuracy and according to your instructions. I have worked on many projects similar to this in the past. You can ask me for a sample if you want. Please share with me the remaining details if you have any and pay me after checking the work. Regards
$35 USD in 1 day
4.9 (12 reviews)
3.4
3.4
User Avatar
Hello, this is not a complicated task. I can help you in this. I do bektesty or more complex betesty. I have been trading in the stock market and the topic to me as interesting.
$30 USD in 1 day
5.0 (4 reviews)
3.0
3.0
User Avatar
Dear Hiring Manager, I have read your job description. I have proper experience about many data entry, research, internet research, market research, information research, data collection, data input, MS word, Excel sheet, power point etc. if you consider me for this project ,i will try my level best.i look forward to hearing from you. Regards, Lucky
$13 USD in 1 day
0.0 (1 review)
0.0
0.0
User Avatar
I am Data Entry/Data Processing Expert who knows the value of time, very hard working and always delivers the work on time. My Motive is to make my employer happy without adding additional charges. If you are looking for data entry or search work, I am the Right person for you. available 24-7. a trusted Freelancer Note:: Please be advised. Pakistani/Indian/bangladeshi workers/employers please do not hire me, if you do i will mark you as spam.
$35 USD in 1 day
0.0 (0 reviews)
0.0
0.0
User Avatar
This price is according to your project's length.
$3,333 USD in 1 day
0.0 (0 reviews)
0.0
0.0
User Avatar
I am an expert in data mining and predictive modeling. I have a PhD in Physics and I have extensive experience in machine learning applications, statistics and software development (web, mobile, desktop, SaaS). I work with R, Python, Spark, SQL, noSQL, Hadoop, .NET, Java, Angular JS, Quantopian, C#, and Tableau. Quantopian may be a better option, it is free as well.
$1,000 USD in 12 days
0.0 (0 reviews)
0.0
0.0
User Avatar
A proposal has not yet been provided
$10 USD in 1 day
0.0 (0 reviews)
0.0
0.0
User Avatar
Hi I'm up for the job since I work in the financial industry and have been investing and trading the markets for 8-years now
$20 USD in 5 days
0.0 (0 reviews)
0.0
0.0
User Avatar
I have done of work in the field of data analytics. I have done lot of analysis with stock price analysis in excel.
$35 USD in 2 days
0.0 (0 reviews)
0.0
0.0

About the client

Flag of UNITED STATES
Arverne, United States
5.0
1
Payment method verified
Member since May 12, 2011

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.