As you may know every company has quarterly results. My current goal is to see what was the effect of the quarter earnings result on the stock market. Here's what I've been doing (let's take Netflix as an exemple):
Step 1 - [login to view URL] - if you look at the upper right you have the date of the earnings. I copy the last eight dates in a spreadsheet. (click left arrow to see past date)
Step 2 - I paste the dates on Google and I Check the closed price a day before and a day after. (For exemple if the earnings release date is 01/20/15, I will write 01/19/15 and 01/21/15 in goole Finance) I repeat the process for the last eight Earnings.
[login to view URL]
Step 3 - I paste the numbers on a % change calculator.
[login to view URL]
Step 4 - I put the % change for a given date in an excel spreadsheet.
Your goal will be to automatize the process, when entering a any Ticker Symbol in Excel the script must fill the table with Data. The Table is 2x11 (check attached picture for filled table).
Hi, I have more than 14 years of exp and I am expert in this kind of work. I have completed more than 225 projects. Please look at the feedback left by my employers to know more about my work. Waiting for your positive response. Thanks.