Web Applications Asked on January 3, 2022
Need previous day high/low price of a share.
This formula gives answer
=googlefinance("nse:"&columno.,"high",today()-2.1)
This gives an answer with date and time in separate columns.
But I need only the value of a particular share price.
Will anyone help me out.
knowing it that I am bit late but it may help someone else,
Try =googlefinance("NSE:IDEA","high",WORKDAY( TODAY(), -2 ))
where "NSE:IDEA" is the stock listed in NSE
Currently trying Google Finance in many possible ways as possible to get insights. If anyone wanting me to share more such formula to get specific data, please let me know and I will share. Hope you will share more and more specific formula examples to fetch specific market data based on more and more specific logical requirements to get insights on the market.
Answered by Sujith Ambraith on January 3, 2022
=INDEX( GoogleFinance( "NSE:"&A2 , "all" , TODAY()-2 ) , 2, 2) - Pre. Open
=INDEX( GoogleFinance( "NSE:"&A2 , "all" , TODAY()-2 ) , 2, 3) - Pre. High
=INDEX( GoogleFinance( "NSE:"&A2 , "all" , TODAY()-2 ) , 2, 4) - Pre. Low
=INDEX( GoogleFinance( "NSE:"&A2 , "all" , TODAY()-2 ) , 2, 6) - Pre. Volume
Answered by Vinod GM on January 3, 2022
I think this will help you
=INDEX( IF(ISNA(GOOGLEFINANCE("NSE:"&A2,"high",TODAY()-1))=TRUE, IF(ISNA(GOOGLEFINANCE("NSE:"&A2,"high",TODAY()-2))=TRUE, GOOGLEFINANCE("NSE:"&A2,"high",TODAY()-3),GOOGLEFINANCE("NSE:"&A2,"high",TODAY()-2)),GOOGLEFINANCE("NSE:"&A2,"high",TODAY()-1)),2,2)
This will fetch the previous day market high.
Answered by dgnk on January 3, 2022
Get help from others!
Recent Answers
Recent Questions
© 2024 TransWikia.com. All rights reserved. Sites we Love: PCI Database, UKBizDB, Menu Kuliner, Sharing RPP