Google Correlate/ Stock charts

In Progress

Hi, I would like someone who can input the historical price and volume data of the S&P 500 stocks into Google Correlate, which will then give me the search terms whose search frequency best matches that data. The results should be sent to me in 1 clearly labelled and set out Excel file. I have detailed instructions on how to do this below, but if you have a quicker way of doing it feel free to use it.

Step 1. Select the first company from the S&P500 ( list found here:[url removed, login to view])

Step 2. Enter the company's ticker into Yahoo Finance ([url removed, login to view])

Step 3. On the lefthand bar, select historical prices. Then select Weekly. Select start date 01 Feb 2005.

Step 4. Click Download to Spreadsheet at the bottom of the page

Step 5. The dates will be descending order e.g. from 26/08/2013 to 27/01/2005 (DAY/MONTH/YEAR). Select the column of dates, then use CTRL + 1 to access the format page. Select date in the format box, then select locale English (US). Then choose the date format 3/14/2001 (Month/Day/Year). All dates in the date column must be transformed into MONTH/DAY/YEAR format.

Step 6. Create 2 new excel files in the .csv format. In the first file, copy the original date column and paste it in as the first column. Copy the column of CLOSE data in as the second column. There should now be two columns, with no headers and with numbers starting in the first row. Save this as (ticker name)Close.csv- e.g. AAPLCLOSE.csv. The second file will be the same, except the second column will be the VOLUME column from the original excel file. Save this as tickernameVOLUME.csv.

Step 7. Got google correlate at [url removed, login to view]

Step 8. Click Enter your own data. Click Choose your file. Select the .csv file of CLOSE data you have just made (e.g. AAPLCLOSE). Give the Time Series a name, say Apple. Click Search Correlations.

Step 9. A new screen with terms and correlations should appear, looking something like the picture in this website: [url removed, login to view] Click show more twice. Copy the correlations and the search terms into an excel file.

Step 10. Now click the Shift series down arrow so it shows -1. Click show more twice again, then copy and paste the correlations and search terms again.

Click the Shift series down arrow again so it shows -2. Click show more twice again, then copy and paste the correlations and search terms again.

Step 11. Repeat steps 8 through 10 for the VOLUME file for the same ticker (e.g. AAPLVOLUME)

Step 12. Repeat Steps 1 through 11 for all the other stocks in the S & P 500.

Step 13. Send all results to me in 1 clearly labelled excel file.

Skills: Data Entry, Excel, Web Scraping, Web Search

See more: google correlate, stock correlate, yahoo-finance, wiki website us, wiki free website, steps on how to create a website, start a wikipedia page, how to start a wikipedia page, how to create website free on google, how to create a wikipedia page, create a new website on google for free, hi charts, google search numbers, g finance, yahoo finance google, step for doing data entry, google trends, google spreadsheet data entry 2, finance excel data, excel charts, create charts csv file, wikipedia list data entry company, access google spreadsheet, create google spreadsheet, yahoo stock csv

Project ID: #4890563

Awarded to:

Scorpio1987

Hi. this is Gopinadh. I am expert in automation and web scraping. This can be done using automation script. Even before applying this i tried this because i want to make sure that this can be automated. Yes this can be More

$170 USD in 2 days
(18 Reviews)
4.7

9 freelancers are bidding on average $196 for this job

Dhruvika111

Dear storagehold2, Greetings! My name is Dhruvika and I am the Account manager at N-office Solutions. I have reviewed the project requirements and would like to offer our exclusive web research and data entry servi More

$185 USD in 3 days
(150 Reviews)
7.1
Balakabd

Hello, I am very much interested to work with u .. Surely project will be done with 100% accuracy and perfectly on time ... I am involve with forex Market so, this experience can help me to support u more accurately .. More

$250 USD in 5 days
(80 Reviews)
6.7
sy3d

Please check my reviews for my expertise area and buyers saying about my work, if you check my reviews then you see, i've no incomplete project and no bad wording for my work please check my profile here http://www.f More

$200 USD in 4 days
(158 Reviews)
6.5
maverick44000

Hi StorageHold. I have read the instructions and ready to start on your project. It is quite time consuming and tedious. Apparently there does not seem a way to have it automated. I am however ready to kick off with More

$260 USD in 3 days
(8 Reviews)
4.4
MSExcelPro

Hi. That sounds easy. Can do it very quickly in the next few days. Let's talk and you can give me more details

$170 USD in 2 days
(1 Review)
1.4
danhamilton1111

Hi, I am a web developer with extensive knowledge of working with google apps, csv files and excel. I am extremely proficient and am comfortable working with google stocks. I am available to start immediately.

$155 USD in 3 days
(0 Reviews)
0.0
CoandaR

Hello Sir, I am a german student at the Economics Universitie of Vienna and I am sure I can do this work for you. If you want to discuss any other detail, I am more than happy to talk.

$155 USD in 3 days
(0 Reviews)
0.0
jitu3332

Hi I have 9.5 Years of experience in Sales, Marketing and Debt reconstructing In Banking & IT Industries . A qualified Electronics engineer with an MBA in IT & Systems. Its my time as a freelancer but am very good with More

$222 USD in 3 days
(0 Reviews)
0.0