Bid and Ask quantities are used by traders for trend analysis. In this tool we extract them for 200 NSE stocks and capture them every 5 minutes.
Data comes from nseindia site and updated every 1 minute.
The different columns are as below.
A. Scrip name
C. Total Bid amount at any time.(Total bid quantity is multiplied with stock price.
D. Total Ask amount at any time.(Total ask quantity is multiplied with stock price.
F. Highest of the best 5 bids(in Rs. Lakhs). The highest bid quantity is multiplied with corresponding bid price.
G. The bid price corresponding to highest quantity.
H. Highest of the best 5 asks(in Rs. Lakhs). The highest ask quantity is multiplied with corresponding ask price.
I. The ask price corresponding to highest quantity.
Data is captured in every 5 min for eod analysis. Tool runs from 9am to 3pm.
Example: The highest bid of Reliance at 9:20 was Rs. 58 Lakh at price 1158.9
https://docs.google.com/spreadsheets/d/1WalOS_-4BnUAh2NJKqPz6-5oNxjI_iurmFq5U8NWTto/edit?usp=sharing
People who want to explore more with their strategy on this can contact me. Will create a new screen which will show up stock names when buy/sell condition matches in live market.
Data comes from nseindia site and updated every 1 minute.
The different columns are as below.
A. Scrip name
C. Total Bid amount at any time.(Total bid quantity is multiplied with stock price.
D. Total Ask amount at any time.(Total ask quantity is multiplied with stock price.
F. Highest of the best 5 bids(in Rs. Lakhs). The highest bid quantity is multiplied with corresponding bid price.
G. The bid price corresponding to highest quantity.
H. Highest of the best 5 asks(in Rs. Lakhs). The highest ask quantity is multiplied with corresponding ask price.
I. The ask price corresponding to highest quantity.
Data is captured in every 5 min for eod analysis. Tool runs from 9am to 3pm.
Example: The highest bid of Reliance at 9:20 was Rs. 58 Lakh at price 1158.9
https://docs.google.com/spreadsheets/d/1WalOS_-4BnUAh2NJKqPz6-5oNxjI_iurmFq5U8NWTto/edit?usp=sharing
People who want to explore more with their strategy on this can contact me. Will create a new screen which will show up stock names when buy/sell condition matches in live market.