Excel sheet to monitor stock prices any?
#11
(03-25-2015, 10:33 PM)actais Wrote: Hi Guys, how can I download all the data per stocks from amibroker using an afl? For example all volumes per stocks from xxx date to xxx date.

yes
====================================
Get a Daily Stock Guide with
TheDailyHINT plus FREE Stock reports here!
Reply
#12
(03-25-2015, 10:33 PM)actais Wrote: Hi Guys, how can I download all the data per stocks from amibroker using an afl? For example all volumes per stocks from xxx date to xxx date.

1. Create a new formula and insert these codes then save.

Filter=1;
AddColumn(O,"Open");
AddColumn(H,"High");
AddColumn(L,"Low");
AddColumn(C,"Close");
AddColumn(V,"Volume",1.0);
AddColumn(OI,"NFBS",1.0); /*Optional - Net Foreign Buy Sell - change "OI" to AUX1 or AUX2 if needed */

2. right click you new AFL then select "analysis"
3. from the drop down box, select "All Symbols" "Current" or "Filter"
4. select date range
5. click "Explore"
6. press Ctrl+A (Select All) then Ctrl+C (copy)
7. paste (Ctrl+V) in MS Excel

sample output:

Ticker Date/Time Open High Low Close Volume NFBS
^PSEi 8/27/2015 6948.8 7025.24 6946.87 7022.09 14586118 -1239526
^PSEi 8/28/2015 7066.4 7116.16 7063.03 7098.81 11260394 -697043
^PSEi 9/1/2015 7065.09 7139.74 7065.09 7086.86 10297392 887853
^PSEi 9/2/2015 6993.71 7072.46 6887.41 7072.46 8493237 -1948466
^PSEi 9/3/2015 7098.69 7105.76 7079.75 7098.76 6414929 -900539
^PSEi 9/4/2015 7074.28 7082.28 7035.11 7051.78 5840035 -266967
Reply
#13
did u guys really paid for amibroker? lol
Reply
#14
They for sure need to be located somewhere in some stock exchange or some brocker, however old versions of stocks probably can be located via google search or something like that via internet, so go figure anyway. Thanks for askingWink
Reply
#15
I have been using Microsoft Office and especially Excel for some time now and I have to say that it is one of the best softwares ever made. I know that it looks simple but without these softwares, our lives will be too difficuly. I hope that they provide important updates
Reply


Forum Jump:


Users browsing this thread: 1 Guest(s)