Historical Share Price query

Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance

From: StockResearcher (anonymous_at_discussions.microsoft.com)
Date: 04/13/04 

Date: Tue, 13 Apr 2004 13:01:08 -0700

Hi,

I've got a MSN Money query in Excel that allows me to query a bunch of stocks at once to get the CURRENT share price. Is there a way to build a query to pull the share price on some data for a list of companies.

My goal is to build a database of historical prices (quarterly) for a large list of companies.

Thanks in advance.

Relevant Pages

  • Re: A Question of Tables
    ... Without getting into your specific query, ... > price (which should be in the STOCKPRICES table) with this exchange rate. ... > selected lang and currency, ...
    (microsoft.public.sqlserver.programming)
  • Re: Adding a new parent key for a new child record on a subform
    ... The above query will make it impossible to display or enter OrderItems ... Private Sub Form_BeforeInsert ... vendor, simple enough. ... latest price and insert it as this order-line-items new price: ...
    (microsoft.public.access.forms)
  • Re: adding a text string to data from one field in one database to another
    ... After running the other create table query, ... I have items with price breaks a various quantity levels each ... Qty price at that qty price for that qty ... In the database the data needs to be entered into a field (not ...
    (comp.databases.ms-access)
  • Re: Problem in calculation in query
    ... The query "order price totals" is using Grup By because for whatever reason ... Exchange Rate Discount ...
    (microsoft.public.access.gettingstarted)
  • Re: Need help with expression on a query
    ... The code create a form in a webpage and the query is to update the data on ... Part, Description, Price, and Code columns. ... >> In the Form Button Memo I have the following code: ...
    (microsoft.public.access.queries)