|
PureBytes Links
Trading Reference Links
|
Hello AR Holztwarth,
in the Automatic Analyzer window (commonly
referred to the AA window), set filter = 1 and alsoyour
search strategy, for example:
<FONT face="Courier New" color=#ff6820
size=1>
filter<FONT
color=#000000> = 1<FONT
color=#000000>;
freshStocks = close >
2;
AddColumn(freshStocks,
"freshStocks"<FONT
color=#000000>);
AddColumn(<FONT
color=#ff6820>open, <FONT
color=#0000ff>"open", Format = <FONT
color=#ff00ff>1.4);
AddColumn(<FONT
color=#ff6820>high, <FONT
color=#0000ff>"high", Format = <FONT
color=#ff00ff>1.4);
AddColumn(<FONT
color=#ff6820>low, <FONT
color=#0000ff>"low", Format = <FONT
color=#ff00ff>1.4);
AddColumn(<FONT
color=#ff6820>close, <FONT
color=#0000ff>"close", Format = <FONT
color=#ff00ff>1.4);
AddColumn(<FONT
color=#ff6820>volume, <FONT
color=#0000ff>"volume", Format = <FONT
color=#ff00ff>1.4<FONT face=Arial
color=#000000 size=2>);
<FONT face="Courier New"
size=1>
The latter statements locate all stocks in
your current database for which the most recent closing price of a
stock is greater than $2, for instance. In order to receive the latest
quotes that are "fresh", please click in the fields <FONT
face=Arial>Apply to and <FONT
face=Arial>Range of the AA window on the radio buttons
all stocks and <FONT
face=Arial>n last quotations, respectively. Now set
n = 1 to trace only those stocks having
a closing price that is merely one trading day "old"! The idea behind this
approach is simply to obtain each stock only once.
After having finished your search strategy
click on the Export button in the AA
window. In this way you create a .csv
file that is an abbreviated form for the term "comma-separated file". You may
give that file any name such as myStocks, for example, which in turn must be
stored in a folder of your choice. Therefore, your file is denoted by
myStocks.csv located in your preferred
folder. In case you want to process the contents of that file with Microsoft
Excel, for example, then you must double click on <FONT
face=Arial>myStocks.csv, in order to open that file.
Finally, save it by activating the Menu/command <FONT
face=Arial>File >> Save as... and saving it as a
Microsoft Excel Work Sheet having the extension <FONT
face=Arial>.xls to process its contents with Excel immediately
or some time later.
Hope that helps!
Best regards,
Udo
-----Ursprüngliche Nachricht-----
<BLOCKQUOTE
>
<DIV
>Von:
<A title=AR.Holzwarth@xxxx
href="">AR.Holzwarth@xxxx
An: <A title=amibroker@xxxxxxxxxx
href="">amibroker@xxxxxxxxxxxxxxx
Gesendet: Samstag, den 19. Oktober2002
12:03 Uhr
Betreff: [amibroker] Export Quotes
I have beeninactive
for quite a while. Just started with AB again veryrecently. I now have a
small problem for which somebody may have a solutionalready:Iwant
to export the quotes of a group of stocks in a watchlist to an Excelor CSV
file? The function provided in AB only exports the quotes of a singlestock
at a time which may be tedious if one wants to exports a larger
group.Thanks in advanceTinkiPost
AmiQuote-related messages ONLY to: amiquote@xxxxxxxxxxxxxxx (Web page: <A
href="">http://groups.yahoo.com/group/amiquote/messages/)Check
group FAQ at: <A
href="">http://groups.yahoo.com/group/amibroker/files/groupfaq.html
Your use of Yahoo! Groups is subject to the <A
href="">Yahoo! Terms of Service.
|