Free RealTime Data NOW Nest ODIN Trade Tiger Google Yahoo to AmiBroker, Fcharts MS

[josh1]

Re: Free RealTime Data NOW Nest ODIN Trade Tiger Google Yahoo to AmiBroker, Fcharts M

Dear Josh1.

I was trying to save my amibroker database every five minutes by adding the line in sub Timer()

Application.OnTime Now + TimeValue("00:05:00"), AB.SaveDatabase

but instead of five minutes it save every 3 seconds or whenever the imports are made from csv to amibroker.

Could you please help.

You need a counter to do that. Try this. Put this in declarations
Public LastSave as date

find line - RP = Range("B3") in Start Timer subroutine.
Add this below that.

LastSave = Now()

Find line - Call AB.RefreshAll in subroutine Call AmiBroker. Add these lines after that.

If Now() - LastSave > Timevalue("00:05:00")
AB.SaveDatabase
LastSave= Now()
End If

This is not tested. If you get errors google to find out time comparisons in VBA

 

[urabpr01]

Re: Free RealTime Data NOW Nest ODIN Trade Tiger Google Yahoo to AmiBroker, Fcharts M

You need a counter to do that. Try this. Put this in declarations
Public LastSave as date

find line - RP = Range("B3") in Start Timer subroutine.
Add this below that.

LastSave = Now()

Find line - Call AB.RefreshAll in subroutine Call AmiBroker. Add these lines after that.

If Now() - LastSave > Timevalue("00:05:00")
AB.SaveDatabase
LastSave= Now()
End If

This is not tested. If you get errors google to find out time comparisons in VBA

Dear Josh,
Thanks a lot. I have made the change and it works fine. One small change in the above code is to add "Then" at the end of line IF.

If Now() - LastSave > Timevalue("00:05:00") Then

Thanks once again. This will save Ami database from frequent power failures.

 

[trump]

Re: Free RealTime Data NOW Nest ODIN Trade Tiger Google Yahoo to AmiBroker, Fcharts M

Windows 8 (64bit) and Excel 2010 ( 32bit)not working
Any work around?
Excel is showing NA in values area.
Please help.

 

[Snake.Head]

Re: Free RealTime Data NOW Nest ODIN Trade Tiger Google Yahoo to AmiBroker, Fcharts M

Windows 8 (64bit) and Excel 2010 ( 32bit)not working
Any work around?
Excel is showing NA in values area.
Please help.

Read Setup Instructions again....
Check admin privileges
Check RTD feature is enable from broker

 

[trump]

Re: Free RealTime Data NOW Nest ODIN Trade Tiger Google Yahoo to AmiBroker, Fcharts M

Read Setup Instructions again....
Check admin privileges
Check RTD feature is enable from broker

lol, have read a few times , all combinations tried - admin, non-admin, run command, separate partition installation apart from C drive, blah, blah, still no success.
If you want I can give my TV id, you can give a shot, what say?:clapping:

 

[lvgandhi]

Re: Free RealTime Data NOW Nest ODIN Trade Tiger Google Yahoo to AmiBroker, Fcharts M

Dear Josh
so far I was using only nowbackfill.xlsm for backfilling. Tody I downloaded your vwap utility zip and ran the nestvwapbackfill_0.3.exe. Readme.txt is not having all the setup requirements, but for tab. I have only one tab. First I got error regarding 6th column as exchange. As per your rtnow.xlsm, symbol should be sixth column. I brought exchange to sixth column. Then I got msg vwap first column should be start time. That also I did it. Even then mag shows vwap first column should be start time, even if first column is strt time as shown in pic attched.

How to go about it?
Further I would like to knwo whether it will backfill default database or database opened?
Can I have suffix as -I ie NIFTY-I as symbol?

 

[josh1]

Re: Free RealTime Data NOW Nest ODIN Trade Tiger Google Yahoo to AmiBroker, Fcharts M

Dear Josh
so far I was using only nowbackfill.xlsm for backfilling. Tody I downloaded your vwap utility zip and ran the nestvwapbackfill_0.3.exe. Readme.txt is not having all the setup requirements, but for tab. I have only one tab. First I got error regarding 6th column as exchange. As per your rtnow.xlsm, symbol should be sixth column. I brought exchange to sixth column. Then I got msg vwap first column should be start time. That also I did it. Even then mag shows vwap first column should be start time, even if first column is strt time as shown in pic attched.

How to go about it?
Further I would like to knwo whether it will backfill default database or database opened?
Can I have suffix as -I ie NIFTY-I as symbol?

Are you using NOW or Nest? If NOW, you should have NOWVwapBackfill_0.3.5
This utility has no connection with RTNOW.xlsm.

You can have any suffix of your choice. It will add that suffix to Symbol.

 

[lvgandhi]

Re: Free RealTime Data NOW Nest ODIN Trade Tiger Google Yahoo to AmiBroker, Fcharts M

Are you using NOW or Nest? If NOW, you should have NOWVwapBackfill_0.3.5
This utility has no connection with RTNOW.xlsm.

You can have any suffix of your choice. It will add that suffix to Symbol.

I am using nest version 3.10.57.97.7. Hence used nestvwapbackfill_0.3.exe which was in zip downloaded today.
.

 

[josh1]

Re: Free RealTime Data NOW Nest ODIN Trade Tiger Google Yahoo to AmiBroker, Fcharts M

I am using nest version 3.10.57.97.7. Hence used nestvwapbackfill_0.3.exe which was in zip downloaded today.
.

Okay. It will backfill default database if it opens AB. If AB is already open, it will backfill the open database.

You have to arrange columns in Marketwatch as well as in VWAP as per order given in the readme/help file. Thereafter, it complains if Vwap does not open automatically. (This happens sometimes in case of Nest). Close and restart the program.
As for the suffix, you can have anything there.

 

[lvgandhi]

Re: Free RealTime Data NOW Nest ODIN Trade Tiger Google Yahoo to AmiBroker, Fcharts M

Okay. It will backfill default database if it opens AB. If AB is already open, it will backfill the open database.

You have to arrange columns in Marketwatch as well as in VWAP as per order given in the readme/help file. Thereafter, it complains if Vwap does not open automatically. (This happens sometimes in case of Nest). Close and restart the program.
As for the suffix, you can have anything there.

in VwapBackfil.readme.txt, I could not find details of column positioning required for vwap and marketwatch. Can you please post it.