+ Reply to Thread
Results 1 to 3 of 3

Importing Web Query for stock data

  1. #1
    Registered User
    Join Date
    01-19-2017
    Location
    Michigan
    MS-Off Ver
    2013
    Posts
    92

    Importing Web Query for stock data

    I'm sure this has been asked before but....I'll give the rundown, I'm trying to import a web query from money.cnn.com (says to look up certain stocks, etc)as part of a hands on through a textbook, but every time I try to, I get script errors with various websites on that page as well as the stock data page I'm looking up along with no yellow indicator to select the table. Is there any way around these blasted script errors or am I just out of luck?

    Thanks

  2. #2
    Forum Moderator alansidman's Avatar
    Join Date
    02-02-2010
    Location
    Steamboat Springs, CO
    MS-Off Ver
    MS Office 365 Version 2405 Win 11 Home 64 Bit
    Posts
    23,895

    Re: Importing Web Query for stock data

    Here is a VBA function I use to obtain stock quote prices. I am not the originator of this code and I do not remember where or how I obtained it. It might work for you.

    Please Login or Register  to view this content.
    Alan עַם יִשְׂרָאֵל חַי


    Change an Ugly Report with Power Query
    Database Normalization
    Complete Guide to Power Query
    Man's Mind Stretched to New Dimensions Never Returns to Its Original Form

  3. #3
    Registered User
    Join Date
    01-19-2017
    Location
    Michigan
    MS-Off Ver
    2013
    Posts
    92
    Quote Originally Posted by alansidman View Post
    Here is a VBA function I use to obtain stock quote prices. I am not the originator of this code and I do not remember where or how I obtained it. It might work for you.

    Please Login or Register  to view this content.
    Thanks for the reply,but I managed to figure it out. The script errors had nothing to do with it apparently, it was just terribly misaligned for that page (the table selector was at the very bottom under everything).

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. SQL Query loading in MS Query but not importing data to excel
    By sharper1989 in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 05-20-2016, 09:52 AM
  2. [SOLVED] SQL Query loading in MS Query but not importing data to excel
    By sharper1989 in forum Access Tables & Databases
    Replies: 0
    Last Post: 05-19-2016, 09:31 AM
  3. Replies: 5
    Last Post: 05-09-2006, 01:25 PM
  4. Web query to create historical stock data
    By ChrisT in forum Excel - New Users/Basics
    Replies: 3
    Last Post: 04-24-2006, 08:50 PM
  5. importing/ analyzing Yahoo!Finance stock data
    By Paul987 in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 03-17-2006, 12:18 PM
  6. [SOLVED] Web Query With Multiple Stock Symbols & Stock Scouter
    By Manfred in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 03-01-2006, 05:15 PM
  7. Importing Stock Data
    By Nate in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 08-28-2005, 02:05 PM

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