vba - enter ticker symbol "MOT", click button, and download finace datainto spreadsheet

Posted on 2009-12-18
Last Modified: 2013-12-08
I want to be able to enter a ticker symbol in a cell, and hit the cmd button, and it will go out to yahoo finance and download all financial data and history into a spreadsheet...the goal is to compile a spreadsheet of variousfinancial sites and line it up in a spreadsheet...

fo for example, if I enter "MOT" or "YAH", or "WAL" into a specific cell it will go out and pull all data from various web sites and download it into a spreadsheet...
Question by:GlobaLevel
    LVL 7

    Expert Comment

    What's the problem?
    LVL 5

    Expert Comment

    Here is a very basic, not sure what else your looking for... let me know I will try to fix it. :)
    LVL 5

    Accepted Solution

    Here, now it's attached the first didn't attach.  This is only setup for one stock, but you can change the stock and hit update and it will update. It should give a general idea on how to do it. :)

    Write Comment

    Please enter a first name

    Please enter a last name

    We will never share this with anyone.

    Featured Post

    Free Trending Threat Insights Every Day

    Enhance your security with threat intelligence from the web. Get trending threat insights on hackers, exploits, and suspicious IP addresses delivered to your inbox with our free Cyber Daily.

    Suggested Solutions

    Introduction This Article briefly covers methods of calculating the NPV and IRR variants in Excel as well as the limitations in calculating and interpreting IRR results. Paraphrasing Richard Shockley, author of my favourite finance reference tex…
    This article offers some helpful and general tips for safe browsing and online shopping. It offers simple and manageable procedures that help to ensure the safety of one's personal information and the security of any devices.
    Google currently has a new report that is in beta and coming soon to Webmaster Tool accounts. This Micro Tutorial will highlight new features for Google Webmaster Tools.
    This Micro Tutorial will demonstrate in Google Sheets how to use the HYPERLINK function to create live links inside your spreadsheet.

    779 members asked questions and received personalized solutions in the past 7 days.

    Join the community of 500,000 technology professionals and ask your questions.

    Join & Ask a Question

    Need Help in Real-Time?

    Connect with top rated Experts

    9 Experts available now in Live!

    Get 1:1 Help Now