EOD Download/ Convert from NSE and BSE

pkjha30 · #**601** 6th July 2008, 08:22 PM

New Version 2.2.15 Incremental Update.

Rediff link

http://f1mail.rediff.com/bn/br/pjhap...onvert.zip?d=0

Skydrivelink

http://cid-cf8290b687b3435f.skydrive...oadConvert.zip

This Zipped file contains Core exe Version 2.2.15
and EODDlc.mdb.

Overwirte the core exe in programme folder.
Put mdb in DATA folder. If you have run sql update for earlier versions and the one mentioned above in previous post then you need not copy this mdb.

This is just incremental bugfix update. Responds to user feedback and posted error log files.

Please check if BSE indices are now downloaded or not.

Terminating comma in output file is removed as it found to interfare with import by technical software esp FIBOtrader.

Those who have downloaded data earlier ( continuous dates) should only rebuild files using file option.

If using database option then first update database by copying all files to Equities folder and click on Update database NSE etc.The use rebuild files from DB option.
No need to download again.

Message for delivery file removed. Be sure to download files using missing files option. Keep Delivery Folder empty before starting download. This download is from Menu and dates are not needed.

Need Indices data do download required date range. It will be added to data base.

Save header( order of values) for output files can be saved for DB and Files option.

Date option is selected from Advanced input settings. it can be saved and loaded. Changes should be visible immediately.

Feedback is appreciated.Error log file or last few lines containing errors will be appreciated.

Those downloading for the first time please Download Eoddlc Setup file , install and then download this version to update core and database. Links are in previous post.

Helpfile will be next week.

Will continue to do imcremental improvement as per suggestion of kkseal

Feedback by Dr Shukla is appreciated as by others also.

rpc may confirm if BSE download is ok by you.

Someone used it for Vista Home and premium edition. Don't know if succeeded. Could enlighten me.please.

pk

pkjha30 · #**602** 6th July 2008, 08:29 PM

Quote:

Originally Posted by darsh_goswami

changing <last> to <close> in files worked for me. But unfortunately i have deleted all downloaded files ,.. now i will have to go and change manually the converted files in <last> to <close>

Now as far as converting is concern .. sir ,.. do i need to change

CLOSE,<last>,last,9
to
CLOSE,<close>,close,9

for future? or anything else ?

Thanx again ,..
Regards,..
DArsh

You are in for tremendous luck

CLOSE,<last>,last,9
to
CLOSE,<close>,close,9

for future only.

However one needs to remember that first column is not to be changed in any way. Second one and third one can be changed to anything. When using files conversion, these changes will be reflected.( But not for DB conversion.)

For example Fibotrader uses word Symbol, Name instead of ticker etc. so it can be used like this.

Anytime you can regenerate all configuration files by clicking Settings>> Regenerate ini files.

That is only thing to do. and thanks for pointing out.

Download new version. Put mdb in DATA folder.

Now all your deleted files(if deleted by programme ) will be in BACKUP folder.

Nothing to do. Just put one file in DATA/NSE/EQUITIES folder change NSE to BSE for respective exchange.

for FNO it is DATA/NSE/FNO

See if output sequence is as you want it. also format of date is as you want it.

Then click rebuild from files.

It will delete all files in converted folder , copy files from Backup folder and rebuild as per sequence prescribed.

if you manually deleted all files so not saved in backup folder, still not much to worry. The programme will try to download first from cache.Depending upon how many day's history is kept you will get all download in a jiffy.

pk

pkjha30 · #**603** 6th July 2008, 08:40 PM

I need one feedback.

What is the name of field for delivery volume and delivery percent so that it can be easily recognised by TA softwares and which softwares accept these values. I found not many use these data howsoever important they may be.

Once I get feedback I will put a procedure to update these things .

pk

pkjha30 · #**604** 6th July 2008, 08:53 PM

With New version Change Headerformat in txt files as follows

Symbol
Name,Open,High,Low,Close,Volume in the third column
ColumnNo -1----2------3----4
SC_CODE,<ticker>,Symbol,1
SC_NAME,<name>,Name,2
SC_GROUP,<group>,group,3
SC_TYPE,<type>,type,4
OPEN,<open>,Open,5
HIGH,<high>,High,6
LOW,<low>,Low,7
CLOSE,<close>,Close,8
LAST,<last>,last,9
PREVCLOSE,<PREVCLOSE>,prevclose,10
NO_TRADES,<NO_TRADES>,trades,11
NO_OF_SHRS,<vol>,Volume,12
NET_TURNOV,<NET_TURNOV>,turnover,13
TDCLOINDI,<date>,date,14
DeliveryQuantity,<del_vol>,DeliveryVolume,15
DeliveryPercent,<del_per>,DeliveryPercent,16

While converting Select Header option and don't select Meta Header.
in advanced input settings.

For NSE there is no Name field so one can set up template for NSE in FIBOTrader.

It should help

pk

pra · #**605** 6th July 2008, 10:14 PM

Quote:

Originally Posted by pkjha30

You are welcome. That is again a wonderful and light utility by joy.
PR.zip is not archived so you can't get back dated data. You might have to rely on other utility like DE Pro.

pk

Hi Pankaj ji

Again thanks & disturb to you . I have DE 3.0.24 but not DE PRO . Could you provide me DE PRO for FIBO ( helpful lack of archive PR ZIP)? Pl, help because i am worried to feed historical data to FEBO.

Regards

Pra

drshukla · #**606** 6th July 2008, 10:45 PM

Dear Mr Jha.

It is still not working .I have tried every thing as per your advice but I get the same msg.

pl keep me posted.

kirti shukla

drshukla · #**607** 6th July 2008, 11:03 PM

Dear Mr Jha.

I have downloaded ur latest version and as per instruction, installed it in the respactive foldert, AND NOW IT IS WORKING TO ITS FULLEST CAPACITY.

congartulation and thanx for the update.

will eat your head if find any difficulty in future....!!!

meanwhile keep the spirit up and high ....

kirti shukla

pkjha30 · #**608** 7th July 2008, 12:42 AM

Quote:

Originally Posted by drshukla

Dear Mr Jha.

I have downloaded ur latest version and as per instruction, installed it in the respactive foldert, AND NOW IT IS WORKING TO ITS FULLEST CAPACITY.

congartulation and thanx for the update.

will eat your head if find any difficulty in future....!!!

meanwhile keep the spirit up and high ....

kirti shukla

Sure , you are welcome

Will wait for feedback
pk

pkjha30 · #**609** 7th July 2008, 12:45 AM

Quote:

Originally Posted by pra

Hi Pankaj ji

Again thanks & disturb to you . I have DE 3.0.24 but not DE PRO . Could you provide me DE PRO for FIBO ( helpful lack of archive PR ZIP)? Pl, help because i am worried to feed historical data to FEBO.

Regards

Pra

Hi You can visit www.investbulls.com to see if latest version is available and prices. It must be cheaper as it used to be free earlier.

pk

ragh_ash · #**610** 7th July 2008, 09:22 PM

hi pankaj
recently the nse index data is not getting downloaded.
has NSE changed something?
rest -- NSE EOD, BSE EOD, BSE indices working fine for me.
just this small problem.
regards

Similar Threads for: EOD Download/ Convert from NSE and BSE
Thread	Thread Starter	Forum	Replies	Last Post
Download EOD & Historical Data From Here ....	debdas	Data Feeds	139	17th November 2008 07:59 PM
Convert Yahoo .CSV file to Metastock format	saritguha	MetaStock	14	15th May 2008 08:38 PM
How to get realtime data and convert it to metastock format	alexonias	Data Feeds	21	15th April 2008 11:48 AM
How to convert NSE indices CSV files to MS format	saritguha	End of Day	2	21st March 2006 12:34 PM
data download	a_n_i_l	Software	9	25th May 2005 09:17 AM