|
PureBytes Links
Trading Reference Links
|
YES around 1 min to update 9000 stocks
it done in VISUAL basic
I belive you can do it in a vb script to
I would release it
But if everyone hit the server daily it will kill the yahoo server.
For those programers that wants to do it
in script language
amibroker.stocks.GetTickerList(-1)'= all the ticker
amibroker.stocks.Count= number of ticker
must be broken down to 200 quote a call (or whatever yahoo max is)
yahoo delay data
Inet1.URL = "http://finance.yahoo.com/d/quotes.csv?s="; & stock
& "&f=st5l9&e=.csv"
csv = Inet1.OpenURL(Inet1.URL)
yahoo RT
Inet1.URL = "http://finance.yahoo.com/d/quotes.csv?s="; &
stock & "&f=sl1d1t1c1ohgv&e=.csv"
csv2 = Inet1.OpenURL(Inet1.URL)
write csv to a file
write csv2 to a file
and import
amibroker.import 0, "c:\csv.csv", "yahoo2.format"
amibroker.import 0, "c:\csv2.csv", "yahoo1.format"
I tried going to memory but it slower
Set ami2 = amibroker.STOCKS(x).quotations(C23 - 1)
ami2.Date = Val(Date)
ami2.Close = Val(dd)
ami2.OPEN = Val(aa(5))
ami2.high = Val(aa(6))
ami2.low = Val(aa(7))
ami2.volume = Val(aa(8))
Now if i can do a memory import that be great
(tomaz hint hint)
may also work for quote.com if and when we get a plugin
The other problem with this it bog down the machine
everything stops during the import
> nick,
>
> Are you saying you update your 9000 EOD from Yahoo in one minute?
> Please tell us how you do that.
>
> Ralph
|