AmiBroker Tips

friends,

In this thread let us share some of the AmiBroker Tips or FAQ's. It should help us in the long term.

1st Tip,

You can have multiple Timeframes chart say Daily and Weekly as two section in the same screen for a Scrip.

What you need to do is a create a simple forumla using formula editor and specifty timeframe was Weekly or Daily.

in1Minute = 60
in5Minute = 5 * 60
in15Minute = 15 * 60
inHourly = 3600
inDaily = 24 * 3600
inWeekly = 5 * 24 * 3600 + 1 = 432001
inMonthly = 25 * 24 * 3600 + 1 = 2160001

EXAMPLE TimeFrameSet( in5Minute ); // switch to 5 minute frame

/* MA now operates on 5 minute data, ma5_13 holds time-compressed 13 bar MA of 5min bars */

ma5_13 = MA( C, 13 );

TimeFrameRestore(); // restore time frame to original

TimeFrameSet( inHourly ); // switch now to hourly

mah_9 = EMA( C, 9 ); // 9 bar moving average from hourly data

TimeFrameRestore(); // restore time frame to original

Plot( Close, "Price", colorWhite, styleCandle );

// plot expanded average

Plot( TimeFrameExpand( ma5_13, in5Minute), "13 bar moving average from 5 min bars", colorRed );
Plot( TimeFrameExpand( mah_9, inHourly), "9 bar moving average from hourly bars", colorRed );




And Now Question:

Can we Open two instances of AmiBoker? Each Instance Opening a different Database?

Regards
Satya

Hi Satya,

How to export intraday data in .csv format?

Best Regards,
Soumya

This is something I found on a discussion board. Tried it and it seems to work. Hope it helps.

Regards,
Ganesh

========================================================
The easiest way to export quotes to CSV file is to use the below formula from Automatic Analysis window:
(Analysis -> Automatic Analysis)

Filter=1;
AddColumn(O,"Open");
AddColumn(H,"High");
AddColumn(L,"Low");
AddColumn(C,"Close");
AddColumn(V,"Volume",1.0);


1. Open: Analysis->Formula Editor
2. Paste the above formula into formula window
3. Choose Tools->Send to Auto-Analysis menu in the Formula Editor
4. In Automatic Analysis window select Apply to: All Stocks, Range: All quotations (or any other time range or filter, depending on what you need to export)
5. Press Explore button
6. Press Export button, specify the name and press OK

it only works for EoD.
It is my posting to the thread 'Fibotrader: An excellent Free TA Software'.
pls be a bit more careful to post.

thanks,
Soumya

Soumya,

This may not be a perfect method. Neverthless, you can give a try.

In AmiBorker, goto
1. Symbol Menu - > Quote Editor
2. Select the range of records by clicking the 1st record and holding shift key click on the last record.
3. say Ctrl + C and paste it in Excel.


I agree it's not an efficient method.

Satya

For the record, this is from the link below. Dated March

http://www.amibroker.com/kb/2006/03/04/how-to-export-quotations-from-amibroker-to-csv-file/

Yes i know that and also had been acknowledged it in the post.
http://www.traderji.com/50896-post80.html
don't take my word with any bad sense.

thanks & best regards,
soumya

Hi Soumya

Just curious!!
Please don't mind my question, but can you tell me why do you want to export intraday data out from AB.
May be I can give it a try if I know the reason or can suggest some alternate solution.

Best Regards
Coool.

Just expermented a bit with that forumla and looks like it works for intraday data as well.

Filter=1;
AddColumn(Date(),"Date");AddColumn(O,"Open");
AddColumn(H,"High");
AddColumn(L,"Low");
AddColumn(C,"Close");
AddColumn(V,"Volume",1.0);
AddColumn(OI,"Open Interest",1.0);


It gives some error but does the work of exporting the data.


Best Regards
Coool.

could anyone give the code of "Detremine Price at Specific RSI".
There is a problem in AmiBroker Web Forum.

Thanks in Advance,
Soumya