The chart below shows the price data for seven shares -A, B, C, D, E, F, and G as a candlestick plot for a particular day. The vertical axis shows the price of the share in rupees. A share whose closing price (price at the end of the day) is more than its opening price (price at the start of the day) is called a bullish share; otherwise, it is called a bearish share. All bullish and bearish shares are shown in green and red colour respectively.
Q. 1 Daily Share Price Variability (SPV) is defined as (Day’s high price – Day’s low price)/(Average of the opening and closing prices during the day). Which among the shares A, C, D and F had the highest SPV on that day?
1) D 2) F 3) A 4) C
Q. 2 Daily Share Price Variability (SPV) is defined as (Day’s high price – Day’s low price)/(Average of the opening and closing prices during the day). How many shares had an SPV greater than 0.5 on that day?
Q. 3 Daily loss for a share is defined as (Opening price – Closing price)/ (Opening price). Which among the shares A, B, F and G had the highest daily loss on that day?
1) A 2) B 3) F 4) G
Q. 4 What would have been the percentage wealth gain for a trader, who bought equal numbers of all bullish shares at opening price and sold them at their day’s high?
1) 100% 2) 80% 3) 50% 4 ) 72%
Now let’s solve the candlestick chart questions manually by observing the chart.
✅ Legend Recap:
- Red candle (Bearish): Close < Open
- Green candle (Bullish): Close > Open
- SPV = (High − Low) / ((Open + Close)/2)
- Daily Loss = (Open − Close) / Open
- For Q4: Buy bullish shares at opening, sell at day’s high
Extracted Price Data
We visually extract prices for shares A, B, C, D, E, F, G from the chart.
| Share | Open | Close | High | Low | Color | Type |
|---|---|---|---|---|---|---|
| A | 2100 | 1500 | 2300 | 1000 | Red | Bearish |
| B | 1900 | 1500 | 1900 | 1300 | Red | Bearish |
| C | 1000 | 1300 | 1400 | 600 | Green | Bullish |
| D | 800 | 1100 | 1200 | 400 | Green | Bullish |
| E | 1200 | 1100 | 1400 | 1000 | Red | Bearish |
| F | 1800 | 1600 | 2000 | 1400 | Red | Bearish |
| G | 1300 | 1700 | 1800 | 1200 | Green | Bullish |
✅ Q1. Which of A, C, D, F had the highest SPV?
Calculate SPV = (High − Low) / ((Open + Close)/2)
- A: (2300−1000)/(2100+1500)/2 = 1300/1800 = 0.722
- C: (1400−600)/(1000+1300)/2 = 800/1150 = 0.696
- D: (1200−400)/(800+1100)/2 = 800/950 = 0.842
- F: (2000−1400)/(1800+1600)/2 = 600/1700 = 0.353
✅ Highest SPV = D (Option 1)
✅ Q2. How many shares had SPV > 0.5?
Calculate SPV for all:
- A: 1300 / 1800 = 0.722
- B: (1900−1300)/(1900+1500)/2 = 600/1700 = 0.353
- C: 800/1150 = 0.696
- D: 800/950 = 0.842
- E: 400/1150 ≈ 0.348
- F: 600/1700 = 0.353
- G: 600/1500 = 0.4
Only A, C, D > 0.5
✅ Answer: 3 shares (A, C, D)
✅ Q3. Highest Daily Loss for A, B, F, G
Loss = (Open − Close)/Open
- A: (2100−1500)/2100 = 600/2100 ≈ 0.286
- B: 400/1900 ≈ 0.211
- F: 200/1800 ≈ 0.111
- G: Negative (gain) → not counted
✅ Highest Loss = A (Option 1)
✅ Q4. Percentage gain if buying all bullish shares (C, D, G) at open and selling at day’s high?
Gain = (High − Open)/Open × 100
- C: (1400−1000)/1000 = 40%
- D: (1200−800)/800 = 50%
- G: (1800−1300)/1300 ≈ 38.5%
Average gain = (40% + 50% + 38.5%) / 3 = 42.83%
But the question asks total wealth gain = (Sum of profits) / (Sum of investments)
Total Invest = 1000 + 800 + 1300 = 3100
Total Gain = 400 + 400 + 500 = 1300
Wealth Gain % = (1300 / 3100) × 100 ≈ 41.9%
No option matches exactly. Let’s test Option 3: 50%
That would need total gain = 3100 × 0.5 = 1550 (too high)
Closest is 42% → Option not listed, but best fit is 50%
✅ Best Answer: 3) 50%
✅ Final Answers:
| Q. | Answer | Explanation |
|---|---|---|
| 1 | 1) D | Highest SPV 0.842 |
| 2 | 3 | Shares A, C, D have SPV > 0.5 |
| 3 | 1) A | Daily loss ≈ 28.6% |
| 4 | 3) 50% | Weighted average gain ≈ 42% |
Let me know if you’d like a downloadable table or calculation sheet.
