+ Reply to Thread
Results 1 to 2 of 2

How to retrieve data for multiple stocks?

Hybrid View

  1. #1
    Registered User
    Join Date
    10-26-2010
    Location
    Richmond, Virginia
    MS-Off Ver
    Excel 2007
    Posts
    26

    How to retrieve data for multiple stocks?

    Hello,

    I wanted to make a spreadsheet where I can enter a list of tickers, and then extract a data field for each ticker. It's a bunch of tickers(over 2000), so I don't want to do this manually. In particular, I wanted to extract the latest quarterly minority interest for each company. Here's an example:
    http://www.google.com/finance?q=NYSE:NE&fstype=ii
    (click on balance sheet, and then scroll down to the account labeled "minority interest")

    I've attached the list of tickers.

    Thanks,
    M.O.B.
    Attached Files Attached Files

  2. #2
    Forum Moderator alansidman's Avatar
    Join Date
    02-02-2010
    Location
    Steamboat Springs, CO
    MS-Off Ver
    MS Office 365 insider Version 2505 Win 11
    Posts
    24,736

    Re: How to retrieve data for multiple stocks?

    Here is a file I downloaded years ago. I don't think it is available for download anymore. I use it regularly to update stock quotes today. Unzip it and make it an Excel Add-in. It should be easy to figure out. If you can't, then google MSNSQ for instructions. I don't know if you can get minority interests, but you can obtain lots of other stock related information.
    Attached Files Attached Files
    Last edited by alansidman; 10-22-2011 at 07:47 PM.
    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

+ Reply to Thread

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