Stock Price Difference Calculator
$250-750 CAD
Pagato alla consegna
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 - [url removed, login to view] - 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.
[url removed, login to view]
Step 3 - I paste the numbers on a % change calculator.
[url removed, login to view]
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).
Rif. progetto: #7271759
