@@coupleracademy at first I use sparkline(g9,{"charttype","column";"max",100%}). It didn't work. But at first it worked. Then I changed to sparkline(g9,{"charttype","column";"ymin",0;"ymax",max(1)}). Now is okay. I don't know why.. thanks for asking..
Hey there! You can definitely create a SPARKLINE in Google Sheets to show a 52-week high/low with the current price as a dot. Here’s a quick way to set it up: 1. Create the Sparkline for the 52-week high/low: =SPARKLINE(A1:A52, {"charttype", "column"}) Here, A1:A52 is your range for the 52-week prices. 2. Add the current price as a dot: Use the SPARKLINE with options to include a marker: =SPARKLINE(A1:A52, {"charttype", "column"; "highlighted", B1}) Replace B1 with the cell containing the current running price. This will add a marker for the current price on your SPARKLINE. You can adjust the styles and colors to match what you see in your broker's app. If you need more help, feel free to ask!
Excellent presentation. I appreciate the subtitles as well.
glad you liked it!
Crisp and clear! awesome video.
Thanks!
Muchas gracias 🎉
Hello, thanks for the video. Whenever I use column charttype, the result is error. Please help
Hi! What's the error message? Do other parameters for this chart work as expected?
For me (in Argentina) worked splitting each parameter with this character instead of ; \
So it would be like this “chart type”\”winloss”
@@coupleracademy at first I use sparkline(g9,{"charttype","column";"max",100%}). It didn't work. But at first it worked. Then I changed to sparkline(g9,{"charttype","column";"ymin",0;"ymax",max(1)}). Now is okay. I don't know why.. thanks for asking..
How can i add a price line as sparkline for 52 week high low & current running price as dot? Like mostly you can see in your brokers app
Hey there! You can definitely create a SPARKLINE in Google Sheets to show a 52-week high/low with the current price as a dot. Here’s a quick way to set it up:
1. Create the Sparkline for the 52-week high/low:
=SPARKLINE(A1:A52, {"charttype", "column"})
Here, A1:A52 is your range for the 52-week prices.
2. Add the current price as a dot:
Use the SPARKLINE with options to include a marker:
=SPARKLINE(A1:A52, {"charttype", "column"; "highlighted", B1})
Replace B1 with the cell containing the current running price. This will add a marker for the current price on your SPARKLINE.
You can adjust the styles and colors to match what you see in your broker's app. If you need more help, feel free to ask!
is it possible to visualize several sparklines in a single cell?
very good video btw
Thank you! I guess not. You'd first need to merge the data and then draw a combined sparkline, it's something we discuss starting at 14:11