Find Jobs
Hire Freelancers

Backtesting some stock picking ideas - requires only Google finance

$30-250 USD

Completed
Posted about 9 years ago

$30-250 USD

Paid on delivery
Going back 10 years, I'd like to know the returns of stocks that gt added to the S&P500 index. 1) research all stocks added to the index, 2) chart their stock price when being added is announced, the day it is added and currently, 3) compare that return to the overall S&P500 market index return. Could I make money by investing in stocks that get added? Also, is there anyway to know when stocks are going to be added to the index so I can guess ahead of time? Estimate maybe 10 hours of work. I would like the output in Excel.
Project ID: 7115481

About the project

8 proposals
Remote project
Active 9 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
Hi I'm a Trader myself. I have more than 6 years of trading experience. I have done similar projects like this (Testing Efficient Market theory) . I will complete the work within 3 days. In fact i could send you the macros i used to complete for your future projects like this
$66 USD in 3 days
0.0 (0 reviews)
0.0
0.0
8 freelancers are bidding on average $147 USD for this job
User Avatar
Dear employer I am an ACCA member with 5 years experiences as auditor in Grant Thornton (Top 5 audit firm). My working experience: + Senior auditor, analyst, Internal Auditor (Outsource) + Prepared financial statement under IFRS, IAS + As an analyst, I am familiar with prepare financial analysis, investment analysis. + As an internal auditor i did: Compliance audit, Review internal control system, Design the internal control system, make recommend on internal control system. Freelancer experience: + Prepare Financial Statement (IFRS, Australia, Singapore, UK, US GAAP…), Audit report + Bookkeeping: Quickbook, MYOB, Xero + Financial modeling, financial valuation + Financial Statement data entry + Internal control report … Let's have a quick conversation. Hope to receive good news from you... Tran Nhu Cuong, ACCA, CPA - Discuss the question - Send draft to employer - Make revision - Final report
$166 USD in 3 days
5.0 (65 reviews)
5.0
5.0
User Avatar
Hi I would like to work for you. For my work quality and commitment, you may refer to my reviews in FL. I am a qualified professional with 25+ years of experience in Business , Strategy and Finance in US / EU MNCs . Presently I am into my own consulting business. With this background , I will be able to deliver better service for you. My skype ID: sanjib360 Look forward to hear from you. Best Regards / Sanjib
$210 USD in 5 days
4.9 (5 reviews)
3.9
3.9
User Avatar
This is Moonmoon from India. I am an Equity analyst. Basically I am an MBA-Finance with CFA. I can sincerely do this work in the stipulated time frame. I have list of the stocks which have added from the year 2000 in S&P 500 . I have already checked. No stock is added just 10 years ago. From dec 2000 to april'2010, the total stocks have added to the index is10 and among them only 7 is still exist in the index.
$155 USD in 3 days
0.0 (0 reviews)
0.0
0.0
User Avatar
HI I AM AN EXPERT IN EXCEL, VB AND MACROS please send me a message so that we can have a dialogue SKYPE = kapekmonho I have read your request and understand it. I also Trade index futures (South African version of the e mini) Stocks that make the index or leave it are ones which are on either side of the borderline. This must be evaluated on regular basis. S&P 500 is by market cap thus monitor which ones on the borderline are changing relative to each other. I am available now you can access my cell phone number from the freelancer site ------------------------------------------------------------------------------------------------------------------------------------ I have worked with excel for many years and used it for many different purposes. As a result of this I can create user forms, interactive sheets, connect to external databases, create reports and send information to other applications, complex calculations and Models. I can also sort out data as you require. I learnt these skills in laboratory background. At one moment in my career I was LIMS specialist for large complex laboratory. (LIMS – Laboratory information management system) If you have any questions please contact me. I am available now Regards Stuart SKYPE = kapekmonho
$59 USD in 3 days
0.0 (0 reviews)
0.0
0.0
User Avatar
Hello, sir. I have learned and worked at finance and accounting. The S&P 500, or the Standard & Poor's 500, is an American stock market index based on the market capitalizations of 500 large companies having common stock listed on the NYSE or NASDAQ. I have studied Google and Honda. I usually look at K line charts of these companies. Furthermore, I am able to use many financial instruments including stock options, Interest rate option. I usually analyze companies' financial performance with financial statements as I am proficient at US-GAAP. I think I am able to finish the task, Thank you
$100 USD in 2 days
0.0 (0 reviews)
0.0
0.0
User Avatar
Hi, currently I am a research scholar in the area of finance. Earlier I have worked on something similar to the requirement posted by you, that is the return of companies which have come for IPOs. The result is that during the times of market boom, these company share holders make a lot of money and as time passes by, the returns erode. I have worked on the Indian scenario and I can work on the S & P 500 if you provide me the opportunity.
$222 USD in 3 days
0.0 (0 reviews)
0.0
0.0

About the client

Flag of UNITED STATES
New York, United States
5.0
2
Payment method verified
Member since Feb 10, 2015

Client Verification

Other jobs from this client

Stock option pricing
$30-250 USD
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.