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

[TraderFriend]

Josh1/SR....thanks for the utility
i have one problem....
i am able to fetch data from odin to excel,plz tell me...how to update these quotes in F-charts...if you have already discussed it,give me the link
Thanks

 

[SURESH_RAJU]

Download the file and unzip it into a separate folder. There are five files in it.
Following files should be placed in to a folder trusted by Excel else every time you open them enable macros and data connection.
RT3.xlsm - This fetches data from NOW and Yahoo
RTG3.xlsm - This fetches data from NOW and Google
NowBackfil.xlsm - This is to be used to backfill to AmiBroker

These should go into the format folder located below your\Amibroker\path
Nest3.format
RTG3.format

Before trying anything in AmiBroker, create new database maybe C:\AmiBroker\RTdata.


Change your system date setting through Start-Control Panel-Regional and Language Options- Customize> Date tab to dd/mm/yyyy or D/M/yyyy.
Time tab -> short time - HH:MM:SS

If you want realtime feed from now, open applications strictly in following order->
NOW-Excel 2007 or above - RTG3.xlsm or RT3.xlsm.

Do not open both RTG3.xlsm and RT3.xlsm simultaneously. They do not work together and your data may get screwed.

There was a slight error in uploading.--

Those who can create RAM disk can download DATARAM's RAM disk software. Software can be downloaded from
here- http://memory.dataram.com/products-and-services/software/ramdisk. User Manual can be obtained on the same page. In FAQ/Support section, click on User Manual. Screen by Screen instructions are given for creating RAM Drive. Create a RAM disk 5 MB with FAT16 file partition and click on Start RAMdisk.

After installation, if you do not see the new drive in your Windows explorer, You may have to Right Click on MyComputer -Manage- Disk drives. Select the new disk and format it. Alott letter - "R" to the new RAM drive.

Others will get an error. Open Visual Basic in Developer Tab and go to Module1. Find these lines in subroutine MakeCSV().

'MkDir ("C:\RT") 'This will create a folder RT in C Drive.
FileName = "R:\MyCSVG.txt" 'This file is used to write quotes

change these to -
MkDir ("C:\RT") 'This will create a folder RT in C Drive. (Removed the single quote at the left to uncomment this line)
FileName = "C:\RT\MyCSVG.txt" 'This file is used to write quotes

Otherwise download the file RT3.xlsm from here - http://www.4shared.com/file/uJMUw9Q_/RT3.html

and the file RTG3.xlsm from here http://www.4shared.com/file/P_vB5iw4/RTG3.html

I have made the changes. Inconvenience regretted.

Give path for your new database in proper place and enjoy realtime feed.

whether the above system is available for metastock? pl guide

 

[SURESH_RAJU]

Register on their site once. Use the same ID and password.

which file we can use for meta stock updation. I am a novice so unable to modify the commands , actually it open amibroker and i wish to use metastock.
Pl guide
regards

 

[josh1]

@Josh1

Some candle patterns differ from the patterns of the NEST software. The open, high,low,close values also differ and there is a change in the volume numbers. Have I done anything wrong? Please correct and guide me.

NEST gives 1 min. candles. We are taking quotes every 3 sec. Timing differs, so do the open high low close and volume values. Accordingly, candle pattern may differ slightly. e.g. NEST will give candle for 9:15, 9:16, 9:17 etc. Amibroker may create candles for 9:15:01, 9:15:04, 9:15:07 etc. Volume is calculated by deducting cumulative volume upto previous candle from current cumulative volume. These are inherent differences. You are not doing anything wrong.

 

[josh1]

Josh1/SR....thanks for the utility
i have one problem....
i am able to fetch data from odin to excel,plz tell me...how to update these quotes in F-charts...if you have already discussed it,give me the link
Thanks

It is explained somewhere between page 3 to 6 of this thread. Please check.

 

[josh1]

Re: how to get data from ICICI trade racer

Please help.

I am not using ICICI terminal. If you know how to get quotes from ICICI trade racer to Excel, we can take over and feed them to AmiBroker.

 

[josh1]

which file we can use for meta stock updation. I am a novice so unable to modify the commands , actually it open amibroker and i wish to use metastock.
Pl guide
regards

Download utility from this link for Metastock - http://www.4shared.com/file/ilvs3FlM/RTMS.html

You may need help from mrkanitkar to get going. Please note, Metastock is not as user friendly and flexible as Amibroker.

 

[shri_r3]

Good day.

I have a web browser based trading platform called Net.Net developed by Financial Technologies Ltd. This is the online web browser based application given by my broker. Its charting features is hopeless. Till now I use free NSE Tame site to check the charts but it has some delay.
I do have amibroker software and would love to use RT feed.
Plz tell me how can i check whether I have RTD feature in my terminal or this method is applicable only to standalone terminal software like odin etc.

Thank you.

 

[josh1]

Good day.

I have a web browser based trading platform called Net.Net developed by Financial Technologies Ltd. This is the online web browser based application given by my broker. Its charting features is hopeless. Till now I use free NSE Tame site to check the charts but it has some delay.
I do have amibroker software and would love to use RT feed.
Plz tell me how can i check whether I have RTD feature in my terminal or this method is applicable only to standalone terminal software like odin etc.

Thank you.

Check whether there is a "Snap to Excel" or "Link to excel" item. Right-click in Market watch. If not, find another broker who gives NSE NOW platform for trading. NSENOW is the the best and fastest in my opinion.

 

[shri_r3]

Check whether there is a "Snap to Excel" or "Link to excel" item. Right-click in Market watch. If not, find another broker who gives NSE NOW platform for trading. NSENOW is the the best and fastest in my opinion.

Thank you for quick reply. I checked in net.net nothing of that sort. I am also thinking of opening new acc with another broker. Probably will open with zerodha in coming week.