Introduction of Database -
I have got a database in MS-Access in which I import the Stock Market EOD "End of Day" data for NSE "National Stock Exchange of India" Futures Contracts on a daily basis. The database table has got following fields/columns in it -
INSTRUMENT --- whether it is stock future or index future
EXP_DATE --- expiry date of this contract
OPEN_INT --- Open Interest of the contract
TRD_VAL --- Traded VALUE of the contract in Rs - Indian Currency
TRD_QTY --- Total number of shares traded - this is same as VOLUME
NO_OF_CONT --- Total number of shares traded converted into number of contracts
NO_OF_TRADE --- Total number of trades
Sector --- Which sector this contract belongs to
Series --- Which series contract it is out of 4
Price % Chg --- % change in price over the previous day
Timestamp --- Date of the trading session
I have attached a small sample of the database as well as a few snapshots to make it completely clear.
Queries and Reports -
I want a few basic queries to be designed for example -
30 Days Average Volume for each stock.
30 Days Total Volume for each stock.
Comparison of current day volume, with the 30 day average volume of the stock.
I want the results to be SECTOR WISE Sorted. Like all the stocks from BANK Sector , OIL Sector etc. should be shown combined. Please look at the snapshots to become more clear about Sector Wise Sorting issue.
Programmer Qualification -
I am looking for some one who has at least very basic understanding about what the stock market is, what is meant by volume of a stock, what is meant by the bank sector etc. So that I do not have to explain these basic things to him.
If the programmer has already worked on any stock market related database in any format, then that would be an added benefit.
This work is very simple and easy, provided you understand my requirement.
More details can be provided in a very step by step manner, once I receive your bid.
3 freelance ont fait une offre moyenne de 143 $ pour ce travail
I have more than 5 years of experience in database design and writing complex queries. I am teradata certified Master and can handle such projects with ease. Looking forward to work with you. Thanks, Atif Malik