EOD Download/ Convert from NSE and BSE

santoshdts · #**471** 3rd May 2008, 01:38 AM

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 · #**472** 4th May 2008, 07:35 PM

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.

Quote:

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 · #**473** 23rd May 2008, 08:42 PM

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 · #**474** 24th May 2008, 01:40 AM

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/...8zL/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/pjhap...csetup.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 · #**475** 24th May 2008, 07:16 AM

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 · #**476** 24th May 2008, 10:58 AM

Quote:

Originally Posted by 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

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 · #**477** 24th May 2008, 11:59 PM

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.

chintan786 · #**478** 25th May 2008, 07:17 AM

Quote:

Originally Posted by 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.

its Ok Pankaj....i am very content with the thing tht my feedback cme handy to u..and directly or indirectly contributed to improvement in this utility...

I must say u are blessed with gr8t mind and big heart who had taken pain to develop such a useful utility.....

Warm regards

chintan

chintan786 · #**479** 25th May 2008, 07:19 AM

and yes after ur clarification ..tht MCX prob. is solved now... the new utility is working smooth now.

RANJITSINGH66 · #**480** 25th May 2008, 11:18 AM

hi pankaj ,
tussi great ho yaar.itna dimag kahan se mila.dil bhi itna bara hai ki bina kisi swarth ke hamare jaise aam aadmi ko free me istemal karne ke liye itna aacha utlity de diya
tumhe gale lagane ko dil karta hai.
one suggestion now ,it would have been better if both delivery volume and percentage of delivery are given as options while converting.presently you included only delivery volume while converting from nse file. I hope you will look into the matter.
as always dil bag bag ho gaya
RANJITSINGH66

Similar Threads for: EOD Download/ Convert from NSE and BSE
Thread	Thread Starter	Forum	Replies	Last Post
Convert Yahoo .CSV file to Metastock format	saritguha	MetaStock	16	31st August 2010 12:29 AM
How to convert NSE indices CSV files to MS format	saritguha	End of Day	12	30th April 2010 05:00 PM
Download EOD & Historical Data From Here ....	debdas	Data Feeds	140	12th April 2009 12:55 PM
How to get realtime data and convert it to metastock format	alexonias	Data Feeds	21	15th April 2008 11:48 AM
data download	a_n_i_l	Software	9	25th May 2005 09:17 AM