NexusFi: Find Your Edge


Home Menu

 





Database - A Simple Query


Discussion in Traders Hideout

Updated
    1. trending_up 3,082 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:	249
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?
Netherlands & Germany Surge as World Cup Field Narro …
Prediction Markets & Event Contracts
Czechia Live at 52.5% as England Rides 4-2 Wave to Co-Fa …
Prediction Markets & Event Contracts
Thanks Mike. Godspeed.
The Elite Circle
No book, only a stair: journaling fills where price move …
Cryptocurrency
Ninjatrader users - good CONNECTIONs post and article fr …
NinjaTrader
 
Best Threads (Most Thanked)
in the last 7 days on NexusFi
Want your NinjaTrader indicator created, free?
5 thanks
Afternoon-close session
1 thanks
Franks Trading Journey
1 thanks
Denied 20K payouts: Alpha Futures
1 thanks
FootPrintV2 Chart for NT8
1 thanks




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