NSE EOD data into MS-Access

I am using Joy - Data tool for downloading the Futures EOD data from NSE. I have imported that data into MS-Access as shown in the snapshot.

The data is getting imported into "Date wise Tables". Is there some way by which I can import this data into "Symbol wise Tables" ? So that I have the data for each of the Individual Symbols like Aban-I,Aban-II,Aban-III in the Access Tables.
And then I can update this database daily by doing the import of the Daily EOD data file. Any idea if this is possible, and how to do that ?



Thanks

Hi,
I am not sure if such a tool exists for futures for direct use.

You may be able to make a Yah00 watchlist and download quotes and import into Access. I have not done this.

I had a similar need to get stockwise EOD data for NinjaTrader, a TA software with some special data format and I made an AFL to export data from Amibroker to be able to be inputted into NinjaTrader.

If you are using Amibroker & want to see my AFL and modify it to suit your needs, I can post it here.

In case you want, I can modify it to suit your needs. If you are not using / familiar with Amibroker, just ignore this post.

murthymsr

Thank you so much for your very helpful reply murthymsr :thumb::clap:

Right now my Exact Requirement is to get this Symbol Wise EOD Data into MS Access. As I have not seen any one else who has done it before, so I am in doubt now, whether such a thing is possible at all or not

Is it possible to create such a database in MS Access, which could be updated daily with the NSE EOD Data file ?

Can some friend who has some experience in Database related work, please comment on this ? Any one has got the email id of findvikas -
http://www.traderji.com/members/findvikas.html

He seems to have good knowledge of SQL database, so he might be able to tell what should be done here.

Thanks a lot for your help.

Since I have not been able to do this work, now I am looking for some one who could do this for me for a fee. Do you know any one who has some practical knowledge of MySQL and MS-Access ? Rather then getting involved with freelance sites I would prefer if someone from Traderji could do this work. I will pay the money through online bank transfer.

Please suggest if you know someone who could do this work. As Joy has said that this work is not very difficult for someone who has programming knowledge of these database, therefor I think that it will not be very difficult to find some one, who would be able to do this work.

Thanks

PS: you can email or PM me as well.

Hi FrankTrader,

Your requirement can be achieved. Feeds can be pumped into database.
On a very macro level I can say that to achieve your requirement i.e. posting data into symbolic tables , dynamic queries needs to be implemented and I don't think MYSQL supports dynamic queries as of now.
I would look for other databases like Netezza etc.
However, I will confirm and let you if any other free database software has that functionality.
May be you could work with SQL Server Express Edition which is freely available (I believe, I am not sure) and also supports dynamic SQL. I will check the feasibility and let you know.

Regards,
Rohit (rohit6699)

Hi frank,

I have made a basic java file which suits your requirement.
And don worry it is free of cost :thumb:
Pm me your email id.
I will give it to you.

Regards,
Rohit(rohit6699)

Oh i just went through your pm.
got your email id.
will drop you a mail.
cheers...

Rohit(rohit6699)

Thank you rohit for your help. :thumb: