thanks. Can I do a line or bar, showing where a current stock price fall into the 52-week high and low, like they do in Yahoo Finance. for example, if the 52-week range is 20-60, current price is 40, then we show something like this: -------------•------------. The dot shows the current price. Thanks!
You can do a line chart but it won't be able to highlight the current price like it does in Yahoo Finance. Unfortunately, Google Sheets charts don't allow you to highlight a specific gridline in your chart.
@@WorkflowWisdom I tried with a “-“, and it worked. 😀😀Here is the formula: = LET(rate,(hprice-lprice)/20,REPT("-",(cprice-lprice)/rate)&"⦿"&REPT("-",(hprice-cprice)/rate))
The CELL function gives you specific information about your cells. It's a great function to use when you're dealing with a large set of data and you want specifics about your cells. For example, when you want to know if your cell contains plain text, other values or just blank, the CELL Function will help you determine that with this formula: =CELL("Type",A1), if it returns an "l" you cell contains plain text, if it returns a "v" it contains other type of data like numbers and if it returns a "b" that means your cell is blank.
✅Subscribe to my channel for more Google Sheets tips & tricks: youtube.com/@WorkflowWisdom?sub_confirmation=1 👈
thanks. Can I do a line or bar, showing where a current stock price fall into the 52-week high and low, like they do in Yahoo Finance. for example, if the 52-week range is 20-60, current price is 40, then we show something like this: -------------•------------. The dot shows the current price. Thanks!
You can do a line chart but it won't be able to highlight the current price like it does in Yahoo Finance. Unfortunately, Google Sheets charts don't allow you to highlight a specific gridline in your chart.
@@WorkflowWisdom I tried with a “-“, and it worked. 😀😀Here is the formula: = LET(rate,(hprice-lprice)/20,REPT("-",(cprice-lprice)/rate)&"⦿"&REPT("-",(hprice-cprice)/rate))
That is great. Thanks for sharing.
When and why would we need such a function in real life? Any examples you might have?
The CELL function gives you specific information about your cells. It's a great function to use when you're dealing with a large set of data and you want specifics about your cells. For example, when you want to know if your cell contains plain text, other values or just blank, the CELL Function will help you determine that with this formula: =CELL("Type",A1), if it returns an "l" you cell contains plain text, if it returns a "v" it contains other type of data like numbers and if it returns a "b" that means your cell is blank.
@@WorkflowWisdom Thanks a lot for the reply and the information
You are welcome.