[Okta Webinar] Learn how to a build a cloud-first strategyRegister Now

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 459
  • Last Modified:

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

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...
0
GlobaLevel
Asked:
GlobaLevel
  • 2
1 Solution
 
holthdCommented:
What's the problem?
0
 
syeager305Commented:
Here is a very basic, not sure what else your looking for... let me know I will try to fix it. :)
0
 
syeager305Commented:
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. :)
Book1.xls
0

Featured Post

Keep up with what's happening at Experts Exchange!

Sign up to receive Decoded, a new monthly digest with product updates, feature release info, continuing education opportunities, and more.

  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now