|
PureBytes Links
Trading Reference Links
|
Colin,
there are various ways to do this but I suggest that you select an option
that you are comfortable with. If you are versed in Java, you can use an
URLConnection. If you are familiar with Microsoft technology, you can do
something easy with Excel and VBA. Just type your signals into, say, column
A and then in your VBA code, loop through with the following code, which
will download from Yahoo. The following will get quotes from Yahoo beginning
at a certain date:
' Retrieve Yahoo Quotes
On Error Resume Next
With
ActiveSheet.QueryTables.Add(Connection:="URL;http://chart.yahoo.com/table.cs
v?s=" & sSymbol & "&a=" & StartMonth & "&b=" & StartDay & "&c=" & StartYear
& "&d=" & EndMonth & "&e=" & EndDay & "&f=" & EndYear &
"&g=d&q=q&y=1&x=.csv", Destination:=Range("A1"))
.FieldNames = True
.RowNumbers = False
.FillAdjacentFormulas = False
.RefreshOnFileOpen = False
.BackgroundQuery = False
.RefreshStyle = xlInsertDeleteCells
.SavePassword = False
.SaveData = True
.Refresh BackgroundQuery:=False
End With
When you get the results into your SS, just save it into access using
something simple like ADODB.
Sincerely,
Wes Williams
> -----Original Message-----
> From: cwest@xxxxxxxxxxxx [mailto:cwest@xxxxxxxxxxxx]
> Sent: Monday, November 19, 2001 12:12 PM
> To: Omegalist
> Subject: MS Access "downloader" driver
>
>
> Has anyone done anything they'd care to share or know of a driver or
> "something" that'll retrieve EOD data from any of the free
> Internet sources
> and automatically load it into MS Access or some other DB that has an open
> connection? I'm trying to spec a portfolio management application and need
> historical data for symbols (in transactions) for analysis and reporting.
>
> Thanks in Advance
> Colin West
>
>
|