NexusFi: Find Your Edge


Home Menu

 





Database - A Simple Query


Discussion in Traders Hideout

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




 
Search this Thread
  #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:	260
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?
Bitcoin’s 2022 low, 2025 high and 2026 low so far arou …
Cryptocurrency
What we know about Binances $6.3bn hack - BBC News
Cryptocurrency
My Rant with AMP Futures
Trading Reviews and Vendors
Building a free browser DOM/SMC simulator - need some ad …
Platforms and Indicators
requesting .nrd replay files from 2026 spy and qqq
The Elite Circle
 




Last Updated on October 15, 2011


© 2026 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 - Downloads - Top
no new posts