PDA

View Full Version : NEED Some IEOD FOREX DATA


kssbgt
22nd February 2010, 08:33 PM
Hi All,

I am working on one Amibroker Plugin DLL, developers and contributors are welcome and will get it freely. So it is not 100% free. :D
and need some intraday forex data of 2/3 months to test the plugin DLL
Can any one can provide the data or link ?
-Regards
kssbgt@hotmail.com

kssbgt
26th May 2010, 10:05 PM
When we import date wise old IEOD data in Amibroker it is time consuming job if data is in date wise folders that has same and unique file name with scrip name like NTPC.CSV IDFC.TXT etc

I found one way to combine multi years or multi month data which is stored in date wise folders with unique and same file name

first down load http://bluefive.pair.com/TXTcollector.zip
This is TXTcollector 2.0.1 free utility that combines TXT,CSV files from inner and ramified subfolders in a single txt or csv file,

For example May2010 has all date wise folder like IEOD-2010-05-01 to IEOD-2010-05-31
c:\Data\IEOD-2010-05-01\
NTPC.CSV
IDFC.CSV
ICICI.CSV
c:\Data\IEOD-2010-05-02\
NTPC.CSV
IDFC.CSV
ICICI.CSV
and so on till 31st may 2010

now all these folders having files for each scrip with unique name so IEOD files of each day of MAY-2010 can not be stored in single folder to import them at once in Amibroker it will be time consuming if we want to import selected scrip IEOD data and not all IEOD data.

1) first make sure that all IEOD data is stored in each folde as shown above (this is for DTM IOED zip files like May-2010 JAN-2010 etc )
2) then start Winzip and click new button to make new zip
3) type file name as NTPC for all NTPC IOED data to be stored from all IOED folders of May-2010
4) then add file window will come on screen
5) in the File Name Text box type NTPC*.*
6) after that go to C:\Data\ where all IEOD folders of May-2010 are located
7) and select all May-2010 folders from IEOD-2010-05-01 to IEOD-2010-05-31
8) select check box Include subfolders
9) Now click the button Add with wildcards (this will only add all NTPC Files in Zip folders)
10) Now you have a zip file that has all NTPC IOED files in Date wise folders for May-2010
11) expand this NTPC.zip in a folder named NTPC under c:\Data\
12) now start TXTcollector
13) in Folder Type C:\data\NTPC ( the location ) or u can select it by clicking button Browse Folders
14) Select check box include sub folders
15) 15 select extension as CSV or TXT from drop down list (extension will be ame as u have for all IEOD data files, So select it properly after confirming )
16) Select No separator check box and do not select – No file name check box
17) click button Combine All files
18) first it will combine all NTPC IEOD files of each day from all sub folder in a single file and will ask u the name to save the file. so NAME it as NTPC-IEOD-MAY-2010
19) Now this single file has all IOED data of May-2010 so you can just import this single file in Amibroker rather than selecting and importing IEOD file of each day from each folder for individual scrip file
20) This task can be performed on all IOED data folder like JAN-2010 FEB-2010 MARCH-2010 and single IEOD file NTPC-2010 for year 2010 can be made to import.
21) This process is useful if we only to import OLD IEOD data for selected stocks

kssbgt
26th May 2010, 10:09 PM
When we import date wise old IEOD data in Amibroker it is time consuming job if data is in date wise folders that has same and unique file name with scrip name like NTPC.CSV IDFC.TXT etc

I found one way to combine multi years or multi month data which is stored in date wise folders with unique and same file name

first down load http://bluefive.pair.com/TXTcollector.zip
This is TXTcollector 2.0.1 free utility that combines TXT,CSV files from inner and ramified subfolders in a single txt or csv file,

For example May2010 has all date wise folder like IEOD-2010-05-01 to IEOD-2010-05-31
c:\Data\IEOD-2010-05-01\
NTPC.CSV
IDFC.CSV
ICICI.CSV
c:\Data\IEOD-2010-05-02\
NTPC.CSV
IDFC.CSV
ICICI.CSV
and so on till 31st may 2010

now all these folders having files for each scrip with unique name so IEOD files of each day of MAY-2010 can not be stored in single folder to import them at once in Amibroker it will be time consuming if we want to import selected scrip IEOD data and not all IEOD data.

1) first make sure that all IEOD data is stored in each folde as shown above (this is for DTM IOED zip files like May-2010 JAN-2010 etc )
2) then start Winzip and click new button to make new zip
3) type file name as NTPC for all NTPC IOED data to be stored from all IOED folders of May-2010
4) then add file window will come on screen
5) in the File Name Text box type NTPC*.*
6) after that go to C:\Data\ where all IEOD folders of May-2010 are located
7) and select all May-2010 folders from IEOD-2010-05-01 to IEOD-2010-05-31
8) select check box Include subfolders
9) Now click the button Add with wildcards (this will only add all NTPC Files in Zip folders)
10) Now you have a zip file that has all NTPC IOED files in Date wise folders for May-2010
11) expand this NTPC.zip in a folder named NTPC under c:\Data\
12) now start TXTcollector
13) in Folder Type C:\data\NTPC ( the location ) or u can select it by clicking button Browse Folders
14) Select check box include sub folders
15) 15 select extension as CSV or TXT from drop down list (extension will be ame as u have for all IEOD data files, So select it properly after confirming )
16) Select No separator check box and do not select – No file name check box
17) click button Combine All files
18) first it will combine all NTPC IEOD files of each day from all sub folder in a single file and will ask u the name to save the file. so NAME it as NTPC-IEOD-MAY-2010
19) Now this single file has all IOED data of May-2010 so you can just import this single file in Amibroker rather than selecting and importing IEOD file of each day from each folder for individual scrip file
20) This task can be performed on all IOED data folder like JAN-2010 FEB-2010 MARCH-2010 and single IEOD file NTPC-2010 for year 2010 can be made to import.
21) This process is useful if we only to import OLD IEOD data for selected stocks