Stock Market Database Queries And Reports

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
SYMBOL
EXP_DATE — expiry date of this contract
OPEN_PRICE
HI_PRICE
LO_PRICE
CLOSE_PRICE
OPEN_INT — Open Interest of the contract
TRD_VAL — Traded VALUE of the con…

Leave a Reply

Your email address will not be published. Required fields are marked *