Bid/Offer Ratio analysis:
A new toy based on Bid/Offer ratio. Few months back I joined a paid site to receive stock signals. What I observed is they are looking for stocks where abnormally high bidding/offering comes. Then they ask us to place bid at a slightly higher price. Sometimes it work very well but they stop sending signal after 1 success. Another issue is sometimes the target is reached very fast(less than 1 min). As per their theory market moves well when high quantity buying selling happens. So instead of looking into some fancy technical indicators check the bids.
Then I started thinking to have a tool to capture this data. Data is extracted from ICICI Direct site(Sample).
Sharable Link. Published Link.
Features:
1. Column F and G: This is current Bid and Offer quantity multiplied with the stock price. If you sort the spreadsheet on this field it will show stocks where highest bidding is going on.
2. Column H: The ratio of Bid/Offer quantity.
3. Column B and C: This is the change in Bid/Offer value in last 15 min. So if you sort on this field you will get recent data in terms of absolute amount. Last 15 min means if current time is 10:17 am it will show the data between 10:02 to 10:17.
4. Column D: Ratio of Bid/Offer quantity change in last 15 min
5. Column E: This is another way of evaluating the change in bid/offer quantity in last 15 min. Example: for SBI column E shows 'U10 D-1'. This means bid quantity is increased by 10% and offer quantity is decreased by 1% in last 15 min.
Hint: When bid quantity growing and offer quantity is falling means bulls have upper hand. When both are increasing this means its a close fight between bulls and bears with no clear direction.
Column M onwards UD data is recorded for post market analysis. If some other important data recording is required for post market analysis I have to modify this sheet.
I request the members of Tji to observe the sheet for few days and post their findings. More eyes can see what I cant see alone. I will make necessary changes if required accordingly.
A new toy based on Bid/Offer ratio. Few months back I joined a paid site to receive stock signals. What I observed is they are looking for stocks where abnormally high bidding/offering comes. Then they ask us to place bid at a slightly higher price. Sometimes it work very well but they stop sending signal after 1 success. Another issue is sometimes the target is reached very fast(less than 1 min). As per their theory market moves well when high quantity buying selling happens. So instead of looking into some fancy technical indicators check the bids.
Then I started thinking to have a tool to capture this data. Data is extracted from ICICI Direct site(Sample).
Sharable Link. Published Link.
Features:
1. Column F and G: This is current Bid and Offer quantity multiplied with the stock price. If you sort the spreadsheet on this field it will show stocks where highest bidding is going on.
2. Column H: The ratio of Bid/Offer quantity.
3. Column B and C: This is the change in Bid/Offer value in last 15 min. So if you sort on this field you will get recent data in terms of absolute amount. Last 15 min means if current time is 10:17 am it will show the data between 10:02 to 10:17.
4. Column D: Ratio of Bid/Offer quantity change in last 15 min
5. Column E: This is another way of evaluating the change in bid/offer quantity in last 15 min. Example: for SBI column E shows 'U10 D-1'. This means bid quantity is increased by 10% and offer quantity is decreased by 1% in last 15 min.
Hint: When bid quantity growing and offer quantity is falling means bulls have upper hand. When both are increasing this means its a close fight between bulls and bears with no clear direction.
Column M onwards UD data is recorded for post market analysis. If some other important data recording is required for post market analysis I have to modify this sheet.
I request the members of Tji to observe the sheet for few days and post their findings. More eyes can see what I cant see alone. I will make necessary changes if required accordingly.
AWESOME SHEET. seen this in live market and trying to understand the values. A few requests:
1. Can you please match the timing like: 9:15, 9:30 not like 9:07, 9:15, 9:30 etc.
2. Can this be done in 5 minutes instead of 15 minutes?
3. ICICI bank data link not working.
4. Can you also please include new Banks like Bandhan Bank, AU Bank, RBL Bank etc
5. Can you make this sheet for NIFTY 50 Stocks too?
Thanks in Advance....