Real Time Data Now / Nest Trader to Amibroker, Fcharts

[Raju01990]

Dear sir,

I have found that link code by Happy Singh as afl. code is

_SECTION_BEGIN("AUTO SAVE");
function GetSecondNum()
{
Time = Now( 4 );
Seconds = int( Time % 100 );
Minutes = int( Time / 100 % 100 );
Hours = int( Time / 10000 % 100 );
SecondNum = int( Hours * 60 * 60 + Minutes * 60 + Seconds );
return SecondNum;
}

RequestTimedRefresh( 1 );
SaveTime = Interval() * 1 ;// to increase time Use * 2 or 5 or give the Time directly in number of Seconds
SecNumber = GetSecondNum();
Newperiod = SecNumber % SaveTime == 0;
SecsLeft = SecNumber - int( SecNumber / SaveTime ) * SaveTime;
SecsToGo = SaveTime - SecsLeft;
MinsLeft = floor(SecsToGo/60);
SecsLeft = SecsToGo%60;
GfxSetBkColor( colorBlack) ;
GfxSetTextColor(colorGold);
GfxSelectFont("Comic Sans MS", 12, 400 ); // Font and Size
GfxDrawText("Save After: " + NumToStr( SecsToGo, 1.0, False) + " Secs" ,5,20, 1300, 360, 0);
AB = CreateObject("Broker.Application"); //
if (SecsToGo==1) AB.SaveDatabase ;
_SECTION_END();

:thumb:

Regards
Raju.S

 

[sumantra]

Need more information. Give it in this thread.
http://www.traderji.com/intraday/97418-odin-excel-amibroker-fcharts-backfill.html

This thread is for Now/Nest

I am unable to backfill data for nifty to the amibroker. How can I backfill it? Am I first download the data in excel format from nse website. But after doing so, I am still unable to backfill it to the amibroker. Anyone kindly help me. Moreover I am a EOD trader.

 

[LOVEENAJYOTHI]

Josh Sir,
Its abt ur Excel Utility RTNEST.XLSM,
Did evry bit as instructed,
quotes flickr live alright in RTD sheet n the main sheet --No prob there.

Problem faced:
when click Start Rt ,starts Ami but either Ami exits immdtly or Quotes NOT feeded to Ami.
Checked R drive, "MyCSVNest.Txt" file is created but Empty.

Presently using RTD 1.30 ,but need BID/ASK rates.

Please HELP

OS-WinXP-SP3
Ami-5.90.1
Excel-2007
MS Visual C++ Redstbtble 2005, 2008,2010,2013 installed.
All (available for XP) DotNET FrmWrks installed.

Please HELP
Thank You 4 the Grt selfles work.

 

[josh1]

Josh Sir,
Its abt ur Excel Utility RTNEST.XLSM,
Did evry bit as instructed,
quotes flickr live alright in RTD sheet n the main sheet --No prob there.

Problem faced:
when click Start Rt ,starts Ami but either Ami exits immdtly or Quotes NOT feeded to Ami.
Checked R drive, "MyCSVNest.Txt" file is created but Empty.

Presently using RTD 1.30 ,but need BID/ASK rates.

Please HELP

OS-WinXP-SP3
Ami-5.90.1
Excel-2007
MS Visual C++ Redstbtble 2005, 2008,2010,2013 installed.
All (available for XP) DotNET FrmWrks installed.

Please HELP
Thank You 4 the Grt selfles work.

Start Ami before you click on Start RT. Give snapshot of RTNest.xlsm

 

[LOVEENAJYOTHI]

Start Ami before you click on Start RT. Give snapshot of RTNest.xlsm

ThanQ Josh Sir,

Today did the attempts listed below:

Only one symbol in MW && removed all extra columns in MW except the bare minimum columns exactly as in the NEST sheet.

Refresh Period set to 00:00:03 (it was 00:00:00 before)

The Cells in RTD n NEST sheets were not properly formatted --->formatted the cells (Row A7 onwards)--hope it's okay to do that.

Detected -->> Amibroker--Prefrnces--AFL--Multi Threaded executn was
unselected -->> now set it right ---(Probably the main culprit
in Ami's sudden exit symptom)

Started Ami before clicking START RT (as suggested by you sir)

YES!!! AMI is LIVE & ticking fine.

Now after 5PM will go full throttle & see whether its still working stable---and will post snapshot sir.

A few queries:
Sir will it b okay if MW has around 50 symbols ? --any limitation ?
Free to format Cells A7 onwards ?
Can v add Columns in MW more than Required ? (Rqrd columns+2 Aux colmns
+ few other columns allowed ?)

Thanx for the Kind Help sir

 

[josh1]

ThanQ Josh Sir,

Today did the attempts listed below:

Only one symbol in MW && removed all extra columns in MW except the bare minimum columns exactly as in the NEST sheet.

Refresh Period set to 00:00:03 (it was 00:00:00 before)

The Cells in RTD n NEST sheets were not properly formatted --->formatted the cells (Row A7 onwards)--hope it's okay to do that.

Detected -->> Amibroker--Prefrnces--AFL--Multi Threaded executn was
unselected -->> now set it right ---(Probably the main culprit
in Ami's sudden exit symptom)

Started Ami before clicking START RT (as suggested by you sir)

YES!!! AMI is LIVE & ticking fine.

Now after 5PM will go full throttle & see whether its still working stable---and will post snapshot sir.

A few queries:
Sir will it b okay if MW has around 50 symbols ? --any limitation ?
Free to format Cells A7 onwards ?
Can v add Columns in MW more than Required ? (Rqrd columns+2 Aux colmns
+ few other columns allowed ?)

Thanx for the Kind Help sir

More columns can be added. You have to add them in format file.
Read setup instructions. Most questions will be answered.

 

[LOVEENAJYOTHI]

More columns can be added. You have to add them in format file.
Read setup instructions. Most questions will be answered.

Thank u Josh sir,

From NEST sheet to AMI, Ticks DELAYED around 30 seconds --is it normal ? how can speed up Ami feed ? (currently ther r only 11 ticking symbols in MW) ?, any settings to b modified in module1 ?

Thank u Sir

 

[josh1]

Thank u Josh sir,

From NEST sheet to AMI, Ticks DELAYED around 30 seconds --is it normal ? how can speed up Ami feed ? (currently ther r only 11 ticking symbols in MW) ?, any settings to b modified in module1 ?

Thank u Sir

Try refresh period of 1 sec.for only 11 scrips. 8-9 seconds delay is becoming normal now as I am observing daily. That is the time period between ticks generated at exchange and they reach your terminal.
Compare terminal time with your system clock and you will see.

 

[LOVEENAJYOTHI]

Try refresh period of 1 sec.for only 11 scrips. 8-9 seconds delay is becoming normal now as I am observing daily. That is the time period between ticks generated at exchange and they reach your terminal.
Compare terminal time with your system clock and you will see.

Pls IGNORE my prev post sir, Restarted Excel & All Gud now,delay is barely one sec now.
{the delay i was and im refering to is the delay of feed reaching to Ami from Excelsheet and NOT from Exchnge to Terminal to Ami, bcos from terminal to Excel its almost instant -->AND now after Restart there is barely any perceptible delay in the entire process---> thanx to ur amazing utility}

Thank u soooo much sir, now moving on to Aux1 & AUx2 , if u have readymade format , pls share sir

How can i add Nifty Index to Exel sheet &to Ami from Zerodha trader ,if at all possible sir, is it thru CDS route ? and modifying cell formulae ?

Thank u josh sir.

 

[josh1]

Thank u soooo much sir, now moving on to Aux1 & AUx2 , if u have readymade format , pls share sir

How can i add Nifty Index to Exel sheet &to Ami from Zerodha trader ,if at all possible sir, is it thru CDS route ? and modifying cell formulae ?

Thank u josh sir.

Again, see sample xlsm file. Read Setup instructions. Read Amibroker Guide for ASCII import. Ami should know that you have added two more fields thru $Format statement in the format file. It is there