Ashish Mathur
New Member
- Joined
- Mar 10, 2013
- Messages
- 40
- Office Version
- 365
- Platform
- Windows
Hi,
In range J2:J3, i have 2 Listed Companies - TCS and BAJFINANCE. They have been converted to Stock Data type. In Column L:M, i wish to vertically stack the stock quotes of these 2 Companies for 5 days. So i used this formula in cell L2
=STOCKHISTORY(J2,TODAY()-5,TODAY(),0,0,0,1)
As expected, i get the stock quote of TCS in range L2:L4. How can i modify the formula to get the stock quote of BAJFINANCE in 3 cells below i.e. in range L5:M7.
I know i have to use LAMBDA and VSTACK but i cannot get the syntax right. Could you kindly help me.
Thank you.
In range J2:J3, i have 2 Listed Companies - TCS and BAJFINANCE. They have been converted to Stock Data type. In Column L:M, i wish to vertically stack the stock quotes of these 2 Companies for 5 days. So i used this formula in cell L2
=STOCKHISTORY(J2,TODAY()-5,TODAY(),0,0,0,1)
As expected, i get the stock quote of TCS in range L2:L4. How can i modify the formula to get the stock quote of BAJFINANCE in 3 cells below i.e. in range L5:M7.
I know i have to use LAMBDA and VSTACK but i cannot get the syntax right. Could you kindly help me.
Thank you.
