|
|
| Discuss EOD Download/ Convert from NSE and BSE at the Software within the Traderji.com - Discussion forum for Stocks Commodities & Forex; Originally Posted by pkjha30 Urgent New Patch Ver 2.2.22 due to change in BSE download ... |
|
|||||||
| Notices |
| Software Charting, trading & technical analysis software, trading system development and backtesting. |
 |
|
|
Thread Tools |
| Sponsored Links |
|
#621
13th July 2008, 11:42 AM
|
|||
|
|||
Re: EOD Download/ Convert from NSE and BSE
Quote:
Hi Pankaj, i get data in this format.....the period i have choosen was 1july2008 to 11july 2008...... file downloaded is BSE indices..... i think there is something wrong with this....... take a look.. i am attching file with this message Last edited by chintan786; 14th August 2008 at 12:14 AM. 
|
| Sponsored Links |
|
#622
13th July 2008, 01:15 PM
|
|||
|
|||
|
Re: EOD Download/ Convert from NSE and BSE
Quote:
I could not replicate this issue with any date format.However,there are two things I noticed. One is that output seems to have come from older version where this problem was there. Values corresponding to dates are ok.Second one is that your database contains data for indices from various dates, not in continuous sequence. I would advise you to clean database by deleting all data.For this go to Options>>Database Admin>>Clear Dataabse>>Clear EOD_BSE Then Download data with new version and check if problem persists. Please tell me what is your system date format and Dateformat set for EODDlc. (Both are two different things) BSE Dateformat is meant for downloading data and has nothing to do with output which will be governed by Dateformat you set. Order of Output is in Ascending order meaning earlier date will come first and later date will come second. I have run EODDlc with different system date format and also by setting different date format and output seems consistent. pk 
|
|
#623
13th July 2008, 01:43 PM
|
|||
|
|||
|
Re: EOD Download/ Convert from NSE and BSE
Quote:
hi Pankaj, thanks for quick reply... i am using EODLC version 2.2.22...and even updated with new patch also...... i am uploading the file again.. i ahve done wht u sasid and changed the date fomat to m-d-yy format.... but i think the problem is still there.... Chintan786 Last edited by chintan786; 14th August 2008 at 12:14 AM.
|
|
#624
13th July 2008, 02:30 PM
|
|||
|
|||
|
Re: EOD Download/ Convert from NSE and BSE
Quote:
date format mm/dd/yyyy Code:
<ticker>,<name>,<date>,<open>,<high>,<low>,<close>,<volume>,<Turnover>,<Del_Vol>,<Del_per> 100003,AUTO,07/01/2008,3585.58,3595.09,3388.01,3409.47,0,0,0,00.00 100003,AUTO,07/02/2008,3400.39,3519.35,3355.74,3498.05,0,0,0,00.00 100003,AUTO,07/03/2008,3482.5,3500.69,3339.83,3377.76,0,0,0,00.00 100003,AUTO,07/04/2008,3415.33,3456.51,3353.85,3432.41,0,0,0,00.00 100003,AUTO,07/07/2008,3352.75,3529.8,3332.43,3508.96,0,0,0,00.00 100003,AUTO,07/08/2008,3494.52,3506.95,3391.31,3498.38,0,0,0,00.00 100003,AUTO,07/09/2008,3503.31,3626.58,3503.31,3606.02,0,0,0,00.00 100003,AUTO,07/10/2008,3618.95,3642.07,3543.62,3565.67,0,0,0,00.00 100003,AUTO,07/11/2008,3577.29,3600.2,3502.77,3529.44,0,0,0,00.00 Code:
<ticker>,<name>,<date>,<open>,<high>,<low>,<close>,<volume>,<Turnover>,<Del_Vol>,<Del_per> 100003,AUTO,01/07/2008,3585.58,3595.09,3388.01,3409.47,0,0,0,00.00 100003,AUTO,02/07/2008,3400.39,3519.35,3355.74,3498.05,0,0,0,00.00 100003,AUTO,03/07/2008,3482.5,3500.69,3339.83,3377.76,0,0,0,00.00 100003,AUTO,04/07/2008,3415.33,3456.51,3353.85,3432.41,0,0,0,00.00 100003,AUTO,07/07/2008,3352.75,3529.8,3332.43,3508.96,0,0,0,00.00 100003,AUTO,08/07/2008,3494.52,3506.95,3391.31,3498.38,0,0,0,00.00 100003,AUTO,09/07/2008,3503.31,3626.58,3503.31,3606.02,0,0,0,00.00 100003,AUTO,10/07/2008,3618.95,3642.07,3543.62,3565.67,0,0,0,00.00 100003,AUTO,11/07/2008,3577.29,3600.2,3502.77,3529.44,0,0,0,00.00 Code:
<ticker>,<name>,<date>,<open>,<high>,<low>,<close>,<volume>,<Turnover>,<Del_Vol>,<Del_per> 100003,AUTO,7-1-2008,3585.58,3595.09,3388.01,3409.47,0,0,0,00.00 100003,AUTO,7-2-2008,3400.39,3519.35,3355.74,3498.05,0,0,0,00.00 100003,AUTO,7-3-2008,3482.5,3500.69,3339.83,3377.76,0,0,0,00.00 100003,AUTO,7-4-2008,3415.33,3456.51,3353.85,3432.41,0,0,0,00.00 100003,AUTO,7-7-2008,3352.75,3529.8,3332.43,3508.96,0,0,0,00.00 100003,AUTO,7-8-2008,3494.52,3506.95,3391.31,3498.38,0,0,0,00.00 100003,AUTO,7-9-2008,3503.31,3626.58,3503.31,3606.02,0,0,0,00.00 100003,AUTO,7-10-2008,3618.95,3642.07,3543.62,3565.67,0,0,0,00.00 100003,AUTO,7-11-2008,3577.29,3600.2,3502.77,3529.44,0,0,0,00.00 Code:
<ticker>,<name>,<date>,<open>,<high>,<low>,<close>,<volume>,<Turnover>,<Del_Vol>,<Del_per> 100003,AUTO,1-7-2008,3585.58,3595.09,3388.01,3409.47,0,0,0,00.00 100003,AUTO,2-7-2008,3400.39,3519.35,3355.74,3498.05,0,0,0,00.00 100003,AUTO,3-7-2008,3482.5,3500.69,3339.83,3377.76,0,0,0,00.00 100003,AUTO,4-7-2008,3415.33,3456.51,3353.85,3432.41,0,0,0,00.00 100003,AUTO,7-7-2008,3352.75,3529.8,3332.43,3508.96,0,0,0,00.00 100003,AUTO,8-7-2008,3494.52,3506.95,3391.31,3498.38,0,0,0,00.00 100003,AUTO,9-7-2008,3503.31,3626.58,3503.31,3606.02,0,0,0,00.00 100003,AUTO,10-7-2008,3618.95,3642.07,3543.62,3565.67,0,0,0,00.00 100003,AUTO,11-7-2008,3577.29,3600.2,3502.77,3529.44,0,0,0,00.00 If you want to check if you had data in EODDlc just download ODBC Viewer http://www.sliksoftware.co.nz/download/odbcv310.exe and install it. Run the programme and Select System DSN as EODDlc . In Sql query Box just type Code:
Select * from EOD_BSE where ScripCode=100003 order by sDate ASC to delete data use this query Code:
delete * from EOD_BSE where ScripCode=100003 pk
Last edited by pkjha30; 13th July 2008 at 07:16 PM. Reason: corrected typo
|
|
#625
13th July 2008, 03:01 PM
|
|||
|
|||
|
Re: EOD Download/ Convert from NSE and BSE
Quote:
Last edited by chintan786; 14th August 2008 at 12:14 AM.
|
|
#626
13th July 2008, 03:02 PM
|
|||
|
|||
|
Re: EOD Download/ Convert from NSE and BSE
i have replaced 8 by *.... still same error.....in delet command i added this also....
order by sDate ASC..... still same error chintan786
|
|
#628
13th July 2008, 07:18 PM
|
|||
|
|||
|
Re: EOD Download/ Convert from NSE and BSE
Quote:
replace 8 by * and delete one Where instead of two. 'order by sDate Asc' is not needed Sorry for the mistake. pk
|
|
#629
13th July 2008, 09:55 PM
|
|||
|
|||
|
Re: EOD Download/ Convert from NSE and BSE
ya now it is working..... this time i entered ur delete query... but databse remain as it is...
sorry pankaj if i am bothering u....... i am not aware of such things........ after all this i downloaded again.... and it is showing me same kind of wrong data in BSE indicies... chintan
|
|
#630
13th July 2008, 10:30 PM
|
|||
|
|||
|
Re: EOD Download/ Convert from NSE and BSE
Quote:
In that case you can download Data.zip and overwrite your eoddlc.mdb and try again. Master Tables in your DB might be corrupted inadvertently without knowing it. pk
|
| Sponsored Links |
|
|
|
| Bookmarks |
| Thread Tools | |
|
|
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 |
Indemnity, Disclaimer & Disclosure
Notice:
• By visiting Traderji.com you indicate your acceptance of our Forum
Rules Disclaimer & Disclosure and indemnify Traderji.com, its
associates and related parties of all claims howsoever resulting from
the usage of the forum.
• Disclaimer: Trading or investing in stocks & commodities
is a high risk activity. Any action you choose to take in the markets
is totally your own responsibility. Traderji.com will not be liable for
any, direct or indirect, consequential or incidental damages or loss arising out of the use of this information.
• Disclosure: The information in this forum is neither an offer to sell nor solicitation to buy any of the securities mentioned herein.
The writers may or may not be trading in the securities mentioned.
• All names or products mentioned are trademarks or registered trademarks of their respective owners.
General Content Disclaimer Notice:
In light of our policy of encouraging candid, open exchanges of views and the rapid distribution of information originating from many sources, Traderji.com cannot determine the accuracy of information that may be uploaded to the forum. Opinions, advice and all other information expressed by participants in discussions are those of the author. You rely on such information at your own risk. You are urged to seek professional advice for specific, individual situations and not rely solely on advice or opinions given in the discussions. Since Traderji.com is an open and free discussion forum, any comments made by members of this forum in their posts reflect their own views and not of the owner or administrator of Traderji.com. Thus the owner/administrator indemnify themselves of all claims whatsoever and will not be liable or responsible for any members comments/views in this forum Traderji.com. If you find any objectionable or offensive posts made by members of this forum which you would like to bring to our notice for removal then please Contact Us.
