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.