Rip,
Good if u're happy with that data. be careful of duplicate entries bcos of different series types (e.g. EQ BE N1 P1 IL BL E1) in the same stock. Look at these for example - SIRPAPER HINDPETRO NIITLTD - u have 2 series in each. what u need is the EQ. so u hv to delete the other or the second will overwrite the first when u import the data and u end up with the wrong data in yr charts. so that's some work to be done apart from change of the 2 column heads that u pointed out.
Incidentally, I use a powerful text editor called 'Textpad' to bulk handle files for removing the top empty row. u cn download it from http://www.textpad.com/download/index.html. this is a great program and u can open a few hundred files at the same time (obviusly keeping within the limits of your RAM. I do about 200 files at a time).
After opening the files, press F8 to open the "Replace" window and type as follows:
Find what: \nDate (note the backslash)
Replace with: Date
Conditions to select:
Text
Regular Expression
Scope:
All documents
Then click "Replace All" and it's done in all the open files. The top blank row in all open files will be deleted.
Go to 'File' menu & click "Save All".
When u're done and u want to close all files, go to File menu and click "Close All".
The whole process takes under a minute.
Try it out with just 2 files first, to make sure u get it right, before u mess with a whole bunchload of files.
Hope this helps.
Re. Intraday data
I don't use live intraday data. I download and import 5-min intraday data at the end of day from http://in.groups.yahoo.com/group/bse-nse2005/files/STOCKS%20DATA%20FILES/IEOD/. This is at a free yahoo group where u can register. FCharts is able to create the following bars with the 5-min data - 5min 15min 30min 1hr 2hr.
Cheers!
Good if u're happy with that data. be careful of duplicate entries bcos of different series types (e.g. EQ BE N1 P1 IL BL E1) in the same stock. Look at these for example - SIRPAPER HINDPETRO NIITLTD - u have 2 series in each. what u need is the EQ. so u hv to delete the other or the second will overwrite the first when u import the data and u end up with the wrong data in yr charts. so that's some work to be done apart from change of the 2 column heads that u pointed out.
Incidentally, I use a powerful text editor called 'Textpad' to bulk handle files for removing the top empty row. u cn download it from http://www.textpad.com/download/index.html. this is a great program and u can open a few hundred files at the same time (obviusly keeping within the limits of your RAM. I do about 200 files at a time).
After opening the files, press F8 to open the "Replace" window and type as follows:
Find what: \nDate (note the backslash)
Replace with: Date
Conditions to select:
Text
Regular Expression
Scope:
All documents
Then click "Replace All" and it's done in all the open files. The top blank row in all open files will be deleted.
Go to 'File' menu & click "Save All".
When u're done and u want to close all files, go to File menu and click "Close All".
The whole process takes under a minute.
Try it out with just 2 files first, to make sure u get it right, before u mess with a whole bunchload of files.
Hope this helps.
Re. Intraday data
I don't use live intraday data. I download and import 5-min intraday data at the end of day from http://in.groups.yahoo.com/group/bse-nse2005/files/STOCKS%20DATA%20FILES/IEOD/. This is at a free yahoo group where u can register. FCharts is able to create the following bars with the 5-min data - 5min 15min 30min 1hr 2hr.
Cheers!
Last edited: