Results 1 to 9 of 9

stock prices; EOD data from internet

Threaded View

impala096 stock prices; EOD data from... 08-06-2008, 10:21 AM
Tom Schreiner Hi Impala. I'm not going to... 08-06-2008, 11:32 AM
impala096 Awesome Tom, That... 08-06-2008, 11:46 AM
Tom Schreiner Are you speaking of realtime... 08-06-2008, 11:57 AM
yawnzzzz Have either of you found a... 08-07-2008, 02:54 PM
  1. #1
    Forum Contributor
    Join Date
    10-14-2007
    MS-Off Ver
    Excel 2021
    Posts
    121

    stock prices; EOD data from internet

    Created a macro to update end of day (EOD) info for stock prices. I'm able to manually change the stock symbol within the URL line found in the macro to retrieve another stocks data but i want to be able to reference a cell in my spreadsheet instead of having to manually enter within the macro.

    This is a line from the macro that actually retrieves the info from the web:

    "URL;http://ichart.finance.yahoo.com/table.csv?s=GM&a=00&b=2&c=2005&d=06&e=29&f=2020&g=d&ignore=.csv", Destination:=Range("a1"))
    To get data for another stock, i would manually change the "GM" (General Motors Corp) in this line to another stock symbol of interest. How do i automate the process so that it will reference a cell instead?

    Thanks for any help,
    Impala
    Attached Files Attached Files

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1