Realtime data NOW,ODIN,TradeTiger,Google,Yahoo > AmiBroker, Fcharts, Qtstalker

[josh1]

Only one query left joshji,
following are screenshots , In datasheet1 rates are updating exact one minute data
but using RTNEST, In datasheet2 rates are updating every five second.
problem with 5 sec updating is , it gives frequent buy/sale signal even in 15 min chart. The query is, can i feed the data for exact one min. like datasheet1 ????

Shahss

There is a problem in your AFL if it is giving you frequent buy/sell signal in 15 min. chart.
You can feed 1 min. data from RTNest. You will have to change refresh period to 60 seconds. However, you will have to accumulate O,H,L,C prices for 1 min. in four arrays and refresh the Nest Sheet every minute before you transport it to AMIBroker. That will require some coding effort.
In my opinion, correcting you AFL for buy/sell signal will be better solution.

 

[hasmukh007]

Hello josh1 ,

I tried lots and followed your steps and video but my excel file does not show realtime data from now. It show error N//A. Can you please help me?

I am waiting for your reply.

Thanks in advance.

Best regards,
Hasmukh Patel

 

[smarttrade]

How to Change Trading Symbols Name in BackFil Excel file

Dear josh1,
I am using Ztrader Platform and using RTNest xl file for RT Data. I have one query, I have modified A Column From A7 ... NIFTY_F1, USDINR_F1,CRUDEOIL_F1 like this. So Showing in Amibroker, Symbols name is NIFTY_F1, USDINR_F1,CRUDEOIL_F1 . But how to Modify Symbols Name like as this in NowBackfil.xlsm file.

After Pasted Data Table Datas in NowBackfil.xlsm file from A1 column, Script Name is showing NIFTY13FEBFUT. How should i modify this to NIFTY_F1 ?

 

[josh1]

Hello josh1 ,

I tried lots and followed your steps and video but my excel file does not show realtime data from now. It show error N//A. Can you please help me?

I am waiting for your reply.

Thanks in advance.

Best regards,
Hasmukh Patel

You have to tell me what steps you tried preferably with screenshots. Then I shall be able to help you. Please tell me the steps you followed from the Readme file that came with the utility.

 

[josh1]

Re: How to Change Trading Symbols Name in BackFil Excel file

Dear josh1,
I am using Ztrader Platform and using RTNest xl file for RT Data. I have one query, I have modified A Column From A7 ... NIFTY_F1, USDINR_F1,CRUDEOIL_F1 like this. So Showing in Amibroker, Symbols name is NIFTY_F1, USDINR_F1,CRUDEOIL_F1 . But how to Modify Symbols Name like as this in NowBackfil.xlsm file.

After Pasted Data Table Datas in NowBackfil.xlsm file from A1 column, Script Name is showing NIFTY13FEBFUT. How should i modify this to NIFTY_F1 ?

Either change NIFTY13FEBFUT to NIFTY_F1 in Nowbackfil before you click on backfil
or merge the scrips in Amibroker after backfil and delete NIFTY13FEBFUT

 

[reenumlk]

Re: How to Change Trading Symbols Name in BackFil Excel file

Dear josh1,
I am using Ztrader Platform and using RTNest xl file for RT Data. I have one query, I have modified A Column From A7 ... NIFTY_F1, USDINR_F1,CRUDEOIL_F1 like this. So Showing in Amibroker, Symbols name is NIFTY_F1, USDINR_F1,CRUDEOIL_F1 . But how to Modify Symbols Name like as this in NowBackfil.xlsm file.

After Pasted Data Table Datas in NowBackfil.xlsm file from A1 column, Script Name is showing NIFTY13FEBFUT. How should i modify this to NIFTY_F1 ?

You can try this, in Amibroker - Symbol information put the Alias as NIFTY13FEBFUT, then your backfil data should automatically go to NIFTY_F1.

 

[smarttrade]

Re: How to Change Trading Symbols Name in BackFil Excel file

Either change NIFTY13FEBFUT to NIFTY_F1 in Nowbackfil before you click on backfil
or merge the scrips in Amibroker after backfil and delete NIFTY13FEBFUT

Dear josh1,
Thanks for your Reply. I Tried to add this in Excel File. I have added some codes in Backfil.xl File. Now I Could Modified Symbol name Correctly. Kindly view this file .
http://www.ziddu.com/download/21622277/NowBackfil.rar.html

 

[josh1]

Re: How to Change Trading Symbols Name in BackFil Excel file

Dear josh1,
Thanks for your Reply. I Tried to add this in Excel File. I have added some codes in Backfil.xl File. Now I Could Modified Symbol name Correctly. Kindly view this file .
http://www.ziddu.com/download/21622277/NowBackfil.rar.html

Dear Smarttrade,

Your code is working correctly for Futures only. However I got some other idea from it. I added some simple find-replace buttons. Please download the files again and see.

If you can add a Table of Contents to the Readme file, it will be really helpful. I am not able to do it.

 

[jarjis_sk]

Can someone please upload the active links

Regards,
Jshaik

 

[ajeetsingh]

Sir, i have tried RT google and got below error:

RUNTIME ERROR 9
SUBSCRIPT OUT OF RANGE

please help