|
PureBytes Links
Trading Reference Links
|
Here is another tip with Excel and grabbing data from the internet.
In excel there is facility to read internet based data Data-Import External
Data This will hyperlink that data straight into excel. There is a toolbar
"External Data" to help with refreshing etc.
When you bring it up it has location to type in URL and then you select a
table, eg course of sales table. The data is then placed in the spreadsheet
where you want it. It can then be refreshed, or if you need more then
copy/paste to elsewhere and change the URL eg ticker name.
Cheers,
Graham
http://e-wire.net.au/~eb_kavan/
-----Original Message-----
From: Dave Merrill [mailto:dmerrill@xxxxxxx]
Sent: Thursday, August 12, 2004 8:11 PM
To: amibroker@xxxxxxxxxxxxxxx
Subject: RE: [amibroker] Attn: Stefan F (Was: Heads up with XP SP-2 and
Metastock Downloader)
Just a heads-up: In Excel, Ctrl-semicolon types the current date. I don't
know of a way to type it including the current time, if you need that too,
but it could definitely be programmed as a macro and given a shortcut.
Dave Merrill
> G> if so I would be happy to help create a spreadsheet to manage the
> G> data into usable format.
>
> I have taken another look at this, and it just might work. Unlike AB
> (ahem, TJ) ^_^ Excel remembers its minimized screen position
> *between* sessions (AB remembers it only as long as it is open, but
> apparently not between sessions).
>
> And since I'd need only 6 fields, Date, Open, High, Low, Close,
> Volume, I think it could be made as small as the DL is now.
>
> This would not be as fast as using the DL, (all I have to do is input
> and hit F5 when AB is open), but it might be a workaround I'd need to
> consider. I think I could get Automate to do some of the automatic
> drudgery that it now does for the DL, like putting fresh dates in the
> date field of every issue before I bother inputting data.
>
> What do I need to do?
>
> Yuki
Check AmiBroker web page at:
http://www.amibroker.com/
Check group FAQ at:
http://groups.yahoo.com/group/amibroker/files/groupfaq.html
Yahoo! Groups Links
------------------------ Yahoo! Groups Sponsor --------------------~-->
Make a clean sweep of pop-up ads. Yahoo! Companion Toolbar.
Now with Pop-Up Blocker. Get it for free!
http://us.click.yahoo.com/L5YrjA/eSIIAA/yQLSAA/GHeqlB/TM
--------------------------------------------------------------------~->
Check AmiBroker web page at:
http://www.amibroker.com/
Check group FAQ at: http://groups.yahoo.com/group/amibroker/files/groupfaq.html
Yahoo! Groups Links
<*> To visit your group on the web, go to:
http://groups.yahoo.com/group/amibroker/
<*> To unsubscribe from this group, send an email to:
amibroker-unsubscribe@xxxxxxxxxxxxxxx
<*> Your use of Yahoo! Groups is subject to:
http://docs.yahoo.com/info/terms/
|