AmiBroker Tips

srisara · #1 2nd August 2006, 10:03 AM

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

soumya_b · #2 2nd August 2006, 04:26 PM

Hi Satya,

How to export intraday data in .csv format?

Best Regards,
Soumya

ksganesh100 · #3 2nd August 2006, 04:50 PM

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

soumya_b · #4 2nd August 2006, 05:14 PM

Quote:

Originally Posted by ksganesh100

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

Regards,
Ganes

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

srisara · #5 2nd August 2006, 05:23 PM

Quote:

Originally Posted by soumya_b

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

ksganesh100 · #6 2nd August 2006, 05:49 PM

Quote:

Originally Posted by soumya_b

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

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/

soumya_b · #7 2nd August 2006, 07:20 PM

Quote:

Originally Posted by ksganesh100

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

http://www.amibroker.com/kb/2006/03/...r-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

cooltetra · #8 3rd August 2006, 01:18 AM

Quote:

Originally Posted by soumya_b

Hi Satya,

How to export intraday data in .csv format?

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.

cooltetra · #9 3rd August 2006, 02:50 AM

Quote:

Originally Posted by soumya_b

it only works for EoD.
thanks,
Soumya

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.

soumya_b · #10 27th August 2006, 10:24 PM

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

Thanks in Advance,
Soumya

Similar Threads for: AmiBroker Tips
Thread	Thread Starter	Forum	Replies	Last Post
AmiBroker	karthikmarar	Your Feedback & Suggestions	8	30th July 2006 12:22 PM
Pls Guide Me How To Use Amibroker	coolguru007	AmiBroker	0	16th May 2006 11:29 PM
amibroker	uncle sam	AmiBroker	0	28th December 2004 06:01 PM