Google Correlate/ Stock charts

Budget $30 - $250 USD
Bids 9
Average Bid $196

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.

Post a Project Like This

This project was awarded to

About the Freelancer

Looking to make some money?

  • Set your budget and the time frame
  • Outline your proposal
  • Get paid for your work

Bids on this Project

  • Scorpio1987 Profile Picture

    Scorpio1987

    Bangalore,  India

    I specialize in Web scraping, Web Automation, Bots and Python Applications. I specialize at scraping data from the websites which require you to log in to scrap the data. I use very high level libraries(mechanize, selenium, scrapy, etc.) in python to automate the scraping and other activities. If you need any help in web scraping, please contact me.

    Perl, C Programming, Java, and XML

  • MSExcelPro Profile Picture

    MSExcelPro

    Lisboa,  Portugal

    Business Analysis Manager, VBA Developer and Dashboard Designer, with 20 years of experience using Excel and Access for business reporting and performance analysis. I'm a certified Project Manager Professional by the PMI organization. Prices and deadlines are negotiable, but the work will always be delivered with world-class quality.

    Project Management, Data Entry, Excel, and Microsoft Access

  • danhamilton1111 Profile Picture

    danhamilton1111

    toronto,  Canada

    Specializing in PHP/MySQL/Python

    PHP, Website Design, Data Entry, and Excel

  • CoandaR Profile Picture

    CoandaR

    Brasov,  Romania

    Basic C++, English, German, Romanian language skills

    Translation, Data Processing, Data Entry, and Transcription

  • jitu3332 Profile Picture

    jitu3332

    Kochi,  India

    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 the below skills. Designations Held: Regional Head Sales 2.5 years (2010 - 2013) Regional Debt Manager: 5.5 Years (2005 -2010) Business Development Manager: 1.5 Years (2004 -2005) Companies worked: ICICI Bank Ltd, IBSS, GECE Carrier Overview: Sales Planning & Business Development Strategic Marketing Process Management Debt Service Management Customer Relationship and Service Management Sales and Financial Forecasting Negotiations and Closures Tender Writing (Technical and Commercial) Project Management Training and Resource Development

    Data Entry, Academic Writing, Financial Markets, and Microsoft

  • sy3d Profile Picture

    sy3d

    Okara,  Pakistan

    I am expert in many fields and my main goal is providing an awesome freelance experience. I am effective at multitasking, problem solving and I offer exceptional professional services and advice. I make sure I go above and beyond to meet your requirements and exceed your expectations. I always provide top notch services and meet deadlines as required. My services are wide in range and not only limited to the list below:- * Photo Editing * Logo Design * Graphic Design * Banner Design * WordPress * Data Entry Online/Offline * Downloading / Uploading * PDF Forms * PDF Conversion * Web Scrapping * Excel * Excel forms * Word * Power Point * Database Development * Document Conversion * Data Retrieval from Websites * Product uploading (all platforms) * Internet research * OCR * Preparing Spreadsheets (Csv, .xls) * eBay & Amazon (Listing) * Facebook, Youtube Services

    Visual Basic, Script Install, Banner Design, and Data Processing

  • Dhruvika111 Profile Picture

    Dhruvika111

    Indore,  India

    We are an ITES and consulting firm based in central province of India with excellent infrastructure and resources. We are located in one of the emerging Information technology hub of the country, established in 2008 with a motive of providing multiple services at one place. We are one of the most prominent company in the native market, thanks to the tireless and committed efforts of our employees, we are now into the third year of our operations. Why choose us: *Value Oriented services *Cost effective solutions *Excellent infrastructure *Specific three levels of operations *Dedicated customer support staff *Experience in handling complex tasks What our clients say: These researchers provided outstanding service. Their data collection skills and accuracy are to be commended. Their communication with me was exactly what made the project a big success. Fred key CNI Systems Dhruvika and his team did a great job at entering data into my online shop. The work was carried out quickly and efficiently at a good price. I will definitely be using them again! Adam Leese (Adem Leese UK) N-office Solutions is an ITES firm that is committed towards implementing latest technology and tools in there work schedule to make each and every single minute more productive. N-office solutions has a pool of talented internet executives. Each executive has a strong command in his/her discipline. Our executives are lead by dynamic project managers who bear the responsibility towards the success of the project. At N-office solutions, we work with our clients vision to reach the set milestones. We at N-office understand the value of our clients money and work hard to provide highly accurate and value oriented services at the most reasonable and affordable service rates. Being an ITES firm we bring and implement latest technologies and tool this industry has to offer. Our knowledge gives us the ability to choose the right technology for you and through our expertise, we implement them in the most suitable direction, overall bringing you the most compact solution and a peace of mind. N-office Solutions has a motto of; Learning to Grow, Growing to learn; which is an everlasting process that encourages us to learn new experience from complexities, errors and opportunities we get along the path towards perfection. Recession had created a chaos in the industry; many companies have seen cut backs, salary reductions and even layoffs. Hiring a service provider had become a difficult task as with the recession at play the service rates have gone even higher. This was the time when our market experts came up with highly competitive service rates which created a win-win equation for our clients and for the company. Since then we have implemented a schema of producing high quality results at realistic and reasonable service charges.

    PHP, C Programming, Java, and Python

  • maverick44000 Profile Picture

    maverick44000

    Islamabad,  Pakistan

    I am a devoted freelancer and have been developing MS Outlook and Excel add-ins using .Net technology for many years. Ranging from very basic to utterly complex add-in requirements, I have maintained a 100 percent success rate so far. I am also highly versed in VBA scripting. If you are seeking MS Office product integration with a 3rd party app or need an Excel solution using customized user interface, I can assure you a quality and professional product at the end of the day. Please refer to my clients testimony about my work. Thank you and have a good day.

    C Programming, Visual Basic, .NET, and Windows Desktop

  • Balakabd Profile Picture

    Balakabd

    Dhaka,  Bangladesh

    ProofPoint IT Solution offers high quality, time bound and cost effective IT services.Our services are ideally suited to high volume data entry applications such as, Captcha Entry, Database and Mailing list compilation.We have a workstation consist of 15 pcs with skilled operator of 50 cpm upto 70 cpm entry specialist. No matter how complex your data,ProofPoint IT Solution guarantees an accuracy level of up to 99.99%.It is this focus, on cost competitiveness and uncompromising quality, which is the driving force behind our work. The Data Entry takes place in 3 shifts, 24/7, 365 days with qualified management, supervisors and support personnel. We are specialized in : Web Development & Programming: ---------------------------------------------------- Custom Web Design and Development WordPress Development Joomla Development Raw PHP and Web apps Development Digital Marketing Services: ------------------------------------- SEO SMM Email Marketing Wordpress optimization AD optimization Google ad word and Facebook campaign setup Data Entry Services: ----------------------------- All types of Data Entry Data Conversion (PDF to any) Facebook, Twitter, Youtube, Ebay Marketing Magento Site Experties: ---------------------------------- Free sign up Keyword Search Market Research Form Fillings We have experience as a bookkeeper and proficient in Quickbooks and all kind of accounting job. Responsible for payroll, accounts receivable, accounts payable, answering phones, maintaining 300 member database, mailing out monthly newsletter to members, created flyers and monthly newletter using Microsoft Publisher. Software used included Word, Excel and other Microsoft Office programs. We are providing data entry and data processing services to various sectors in domestic (in Bangladesh) and for ABROAD. We executed a lot of data processing services to private, public limited and government sectors We are having a vast experience in this sector. Our aim is to become the leading provider of outsourced services in Asia and the Pacific by providing our clients with high quality work and at relatively lower costs. We also have the manpower that we can exhaust for projects that require the delivery of quality and quantity results in a timely manner. We aim to provide clients a timely delivery with high quality and cost effective production. We invite you to get in touch with us and assure you that you will not be disappointed.

    Internet Marketing, Data Processing, SEO, and Link Building