NexusFi: Find Your Edge


Home Menu

 





Database - A Simple Query


Discussion in Traders Hideout

Updated
    1. trending_up 2,684 views
    2. thumb_up 0 thanks given
    3. group 1 followers
    1. forum 1 posts
    2. attach_file 2 attachments




 
Search this Thread

Database - A Simple Query

  #1 (permalink)
 ab456 
New Delhi, India
 
Experience: Intermediate
Platform: SierraChart NinjaTrader,
Trading: ES,Stocks, Futures
Posts: 170 since Sep 2011
Thanks Given: 734
Thanks Received: 111

I have got a database in MS-Access in which I import the EOD data for NSE India Futures Contracts on a daily basis. It has got the following fields in it -


Quoting 
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 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

The snapshot of the database is attached.

Can some one please guide me on how to make 2 queries in it.
A - that will show the TOTAL VOLUME of the last 5 days for every single contract.
B- that will show the AVERAGE VOLUME of the last 5 days for every single contract.

I have attached the database as well. It is small size, just 2.5 mb, if you want to see the database.

Thanks for any input.

Attached Thumbnails
Click image for larger version

Name:	Database.png
Views:	146
Size:	487.3 KB
ID:	52105  
Attached Files
Elite Membership required to download: EOD database.zip
Started this thread Reply With Quote

Can you help answer these questions
from other members on NexusFi?
The space time continuum and the dynamics of a financial …
Emini and Emicro Index
Deepmoney LLM
Elite Quantitative GenAI/LLM
ZombieSqueeze
Platforms and Indicators
Are there any eval firms that allow you to sink to your …
Traders Hideout
NT7 Indicator Script Troubleshooting - Camarilla Pivots
NinjaTrader
 




Last Updated on October 15, 2011


© 2024 NexusFi™, s.a., All Rights Reserved.
Av Ricardo J. Alfaro, Century Tower, Panama City, Panama, Ph: +507 833-9432 (Panama and Intl), +1 888-312-3001 (USA and Canada)
All information is for educational use only and is not investment advice. There is a substantial risk of loss in trading commodity futures, stocks, options and foreign exchange products. Past performance is not indicative of future results.
About Us - Contact Us - Site Rules, Acceptable Use, and Terms and Conditions - Privacy Policy - Downloads - Top
no new posts