EOD Download/ Convert from NSE and BSE

[kkseal]

By the newer format i mean the one with the Expiry Date - much more explicit than I II III.

Keep it if you can (The older format can i guess be accommodated through a string manipulation routine with '-' as the delimiter) No big deal even otherwise.

Regards,
Kalyan.

 

[renu daga]

pkjha sir

i tried to pm u but ur box ix fullllllll pls empty it

secondly i wanted to put a requset to uplaod the eod downloader somewhere since ur rediff box is never linked,,,,,it never opens

some of my friends need ur downloader for nse / and futures eod data
can u pls also give me the link of ur adta base if possible

regards
renu

 

[sarvotam]

hello friends,
can anyone help me to download Eod download convert version 0.0.70 ?

 

[santoshdts]

Dear Mr. PKjha

I have recently downloaded amibroker trial version and interested in using the same.. previously i was using FCHARTS and I am New to this topic can u please give the latest link for download and convert NSE/BSE and FNO data .

U can please PM me or mail me on

santosh UNDERSCORE dts AT y a h o o DOT com

THANX and REGARDS

 

[pkjha30]

Hi

can anyone give me some idea as to why NSE is giving erroneous deliveries data file.
I am reproducing the part that contains duplicate scrips but values are different.

20,1175,WENDT,EQ,130,120,92.31
20,1176,WHEELS,EQ,111,111,100.00
20,1177,WILLAMAGOR,EQ,8124,7604,93.60
20,1178,WINDSOR,EQ,5700,5500,96.49
20,1179,WINSOMYARN,EQ,9354,7569,80.92
20,1180,WIPRO,EQ,1955250,996262,50.95
20,1181,WOCKPHARMA,EQ,24343,17408,71.51
20,1182,WSI,EQ,3755,2502,66.63
20,1183,WSTCSTPAPR,EQ,10095,7744,76.71
20,1184,WWIL,EQ,2329594,472974,20.30
20,1185,WYETH,EQ,3040,2535,83.39
20,1186,XLTL,EQ,220634,145872,66.11
20,1187,XPROINDIA,EQ,5107,4085,79.99
20,1188,YESBANK,EQ,1083436,367273,33.90
20,1189,ZANDUPHARM,EQ,17,10,58.82
20,1190,ZEEL,EQ,504905,208453,41.29
20,1191,ZEENEWS,EQ,780014,442838,56.77
20,1192,ZENITHBIR,EQ,6875,5912,85.99
20,1193,ZENITHCOMP,EQ,5082,3930,77.33
20,1194,ZENITHINFO,EQ,3128,2950,94.31
20,1195,ZENSARTECH,EQ,20437,11858,58.02
20,1196,ZICOM,EQ,5735,3577,62.37
20,1197,ZODIACLOTH,EQ,300,156,52.00
20,1198,ZODJRDMKJ,EQ,1165,763,65.49
20,1199,ZUARIAGRO,EQ,12001,6916,57.63
20,1200,ZYLOG,EQ,9374,4013,42.81
24
20,1200,ZYLOG,EQ,71110,22005,30.95
245751,231223,94.09
20,1202,WENDT,EQ,59,50,84.75
20,1203,WHEELS,EQ,1552,926,59.66
20,1204,WILLAMAGOR,EQ,1151,813,70.63
20,1205,WINDSOR,EQ,71,71,100.00
20,1206,WINSOMYARN,EQ,745,733,98.39
20,1207,WIPRO,EQ,1649323,526610,31.93
20,1208,WOCKPHARMA,EQ,32741,22396,68.40
20,1209,WSI,EQ,12170,10384,85.32
20,1210,WSTCSTPAPR,EQ,156068,68393,43.82
20,1211,WWIL,EQ,7355069,1730821,23.53
20,1212,WYETH,EQ,8821,4437,50.30
20,1213,XLTL,EQ,134724,76423,56.73
20,1214,XPROINDIA,EQ,12594,7760,61.62
20,1215,YESBANK,EQ,1455398,399990,27.48
20,1216,ZANDUPHARM,EQ,14,10,71.43
20,1217,ZEEL,EQ,2659054,1605916,60.39
20,1218,ZEENEWS,EQ,856844,423383,49.41
20,1219,ZENITHBIR,EQ,1340,1130,84.33
20,1220,ZENITHCOMP,EQ,20764,13762,66.28
20,1221,ZENITHINFO,EQ,1368,759,55.48
20,1222,ZENSARTECH,EQ,25551,17326,67.81
20,1223,ZICOM,EQ,2664,1761,66.10
20,1224,ZODIACLOTH,EQ,350,327,93.43
20,1225,ZODJRDMKJ,EQ,3283,3025,92.14
20,1226,ZUARIAGRO,EQ,31876,12239,38.40
20,1227,ZYLOG,EQ,63547,35997,56.65
Q,67660,32643,48.25

As you may notice it starts from WENDT to ZYLOG.In between two non Regular data line is coming '24' and 'Q,67660,32643,48.25'.

This is quite puzzling.

On further investigation it looks like previous day's data which somehow gets appended to MTO delivery data file of NSE.This I found by comparing Current data with previous day's data.

pankaj

 

[RANJITSINGH66]

hello pkjha,
where are you ? we are waiting for your utility. I have one suggestion, when we download indices data , the output is given as per ***** symbol for indices though your utlity download all indices data from nse website. i think it would be better if output for nse indices data is given in nse symbol format.
thanks and regards .
RANJITSINGH66

 

[pkjha30]

Hi All

Here is new Version of EODDlc.
Version 2.0.4

Compiled as setup file with all necessary runtime files. If you have new files it won't overwrite.
The New link is below.

http://qba17q.bay.livefilestore.com...UHRHlc05vzvKPcAm86XY65qcVOUCSfY8zL/EODDlc.exe

Rediffmail briefcase link is here(does not include MDAC_TYP.exe which if needed could be downloaded from Microsoft website)
http://f1mail.rediff.com/bn/br/pjhapondy///Shared/EODDlcsetup.exe?d=0

Features in brief
NSE EOD, FNO Indices, India VIX, Delivery Data, FNO data, PR.Zip
BSE EOD, Indices, Intraday.
NCDEX Commodity EOD
MCX Commodity EOD
Portfolio size increased to 500 stocks for BSE. This is Historical data /Intraday data beyond March 2006.

ADR for NSE/BSE
Indices Total Delivery Details from Constituent stocks.

Auto Name Change, Symbol change and Updation in database. Files could also be updated.Rebuilding All files from EOD files or DATABASE.
Pivot Points and Announcements Price Details Book Closure details one click away.ADR chart for 10 days data.

Conversion from EOD files and also from DATABASE
Compatible with MetaStock, FCharts, AmiBroker, Fibotrader

you can use ODBC dataConnection from your technical analysis software if supported as Datasource. AmiBroker supports it.
EOD tables are
EOD_NSE
EOD_BSE
EOD_NCDEX
EOD_MCX

There are many small improvements which can not be detailed.

I would like to get feedback on its working.

Doubts would be clarified as much as possible. For problems please give error.log file and details of what exactly happened. Next updates will be patch for executables based on feedback only.

Since this one is much versatile so series started with 2.0.2 In anycase Internal version also came pretty close to it during debugging.

pankaj

 

[chintan786]

EXCELLLLLLENTTTTTTTTTTTTT...... wht to say man.. there is each and evry thing..and working fine also.

ok.. i just downloaded MCX data of last 2 days.. data get downloaded in few sec... but whn i hit converter button it does not get converted in text format...no error message was shown....

1 more thing i want to download Adve- decline ratio for NSE .. ur utility show tht .. but how can i get this data can u plz tell me....

i tried intraday chart option nothing come . why.. same with pivot data also... nothing shown... is i need to keep this open for some more tikme to download data.....


rest i had not checked ..... will tell u if come across ...


warm regards

chintan

 

[pkjha30]

EXCELLLLLLENTTTTTTTTTTTTT...... wht to say man.. there is each and evry thing..and working fine also.

ok.. i just downloaded MCX data of last 2 days.. data get downloaded in few sec... but whn i hit converter button it does not get converted in text format...no error message was shown....

1 more thing i want to download Adve- decline ratio for NSE .. ur utility show tht .. but how can i get this data can u plz tell me....

i tried intraday chart option nothing come . why.. same with pivot data also... nothing shown... is i need to keep this open for some more tikme to download data.....


rest i had not checked ..... will tell u if come across ...


warm regards

chintan

Hi Chintan

About Convert , please have a look at error.log file in BIN folder. also Check if data was really downloaded by going to DATA/MCX or DATA/NCDEX folder. It should have shown in Input files list folder. Also toggle Usedatabase checkbox which is ON by default, if you want to convert from files.Just toggle and select Exchange once and see if problem is sorted out.
I checked up it seems to work here with installer version. The only thing you need to setup is your input/output sequence in Advance Settings Button.DB seems to contain old sequence. not in format S,d,ohlcv, this can be done manually once.

About ADR data, it is in ADR table for both BSE and NSE.As you download EOD for BSE/NSE table gets updated. Chart is shown on stock info page ADR tab.

There is no IntraDay Chart other than from embedded Webbrowser.
Presently Market Info on the tab give Book Closure for the day.
Intraday Tab and Misc Tab is not yet programmed but provided for future development if any.

Pivot point will be shown if you download current EOD data from NSE. You have to select symbol from the DropDown list and click go button. If you have downloaded Delivery data and Indices data in sequence you will get Delivery data for Stocks and Indices as well. These are for display/information purpose.

Data downloaded goes into respective folders and also updated in database if not already present.If data is already in database then programme will record in error.log saying it will create duplicate data etc.

All conversions are through single interface so I suggest you to check each function and give feedback so that patch could be released easily.

Pankaj

 

[pkjha30]

Hi

This is to say Thanks to all who contributed to development of EODDlc by giving feedback, report problems and new requirements.

Many would have become frustrated when new version was not forthcoming.

few names who reported bugs
rajaneesh (limit on portfolio stocks), jayamsuccess(FNO problem), chintan, abcdgetright(BE/EQ problem),rajuwaste(BE EQ problem of nse EOD), raju,saji oommen( too many to list),

and many others who have posted to this thread.

Special thanks to pasha for enticing me to make EODDlc download FNO data from NSE

Special thanks to RSI (Mr R.S. Iyer) who guided me during development od EOD downloads for Commidities data from NCDEX and MCX

Special thanks to kkseal for telling me to do the same for IndiaVIX.

Special thanks to Chintan who first reported that MCX and NCDEX historical downloads are working. I was not very sure if it worked on other computers.

Thanks to all, who have ever visited /posted to this thread or used EODDlc. This is software developed for members of this forum.

I will update rediff briefcase once I get enough feedback. meanwhile please download it from link provided in previous post.

pankaj

ps. it works transparently across proxy without requiring user intervention unless websites itself is blocked.