# Candlestick Charts - How To Make? **URL:** \ **Category:** Ask for Help\ **Created:** [February 10, 2022, 12:02pm UTC](https://community.glideapps.com/t/candlestick-charts-how-to-make/38339 "2022-02-10T12:02:45Z")\ **Posts on this page:** 17\ **Page:** 1
**Author:** ![zalewskicompany](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/zalewskicompany/32/38721_2.png) [@zalewskicompany](https://community.glideapps.com/u/zalewskicompany)\ **Post date:** [February 10, 2022, 12:02pm UTC](https://community.glideapps.com/t/candlestick-charts-how-to-make/38339/1 "2022-02-10T12:02:45Z")
Anyone have any idea how to make candlestick charts in Glide using data from google sheets? I would like the chart to be updated on a regular basis when the data in Google Sheets are updated. // [quickchart.io](http://quickchart.io) I tried [quickchart.io](http://quickchart.io) but there are no candlestick charts by default. // charts in Google Sheets Y scale in charts in Google Sheets starts from zero and I don’t know how to change it - is it possible at all? ---
**Author:** ![Darren\_Murphy](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/darren_murphy/32/47326_2.png) [@Darren\_Murphy](https://community.glideapps.com/u/Darren_Murphy)\ **Post date:** [February 10, 2022, 1:07pm UTC](https://community.glideapps.com/t/candlestick-charts-how-to-make/38339/2 "2022-02-10T13:07:17Z")
What does a candlestick chart look like? Do you have an example? ---
**Author:** ![zalewskicompany](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/zalewskicompany/32/38721_2.png) [@zalewskicompany](https://community.glideapps.com/u/zalewskicompany)\ **Post date:** [February 10, 2022, 5:50pm UTC](https://community.glideapps.com/t/candlestick-charts-how-to-make/38339/3 "2022-02-10T17:50:32Z")
![Screenshot_2022-02-10-18-49-34-13~2](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/5/e/5ea669935712fd997bc9f0fbd63d13da81009ab6.jpeg) ---
**Author:** ![ThinhDinh](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/thinhdinh/32/49_2.png) [@ThinhDinh](https://community.glideapps.com/u/ThinhDinh)\ **Post date:** [February 10, 2022, 11:47pm UTC](https://community.glideapps.com/t/candlestick-charts-how-to-make/38339/4 "2022-02-10T23:47:32Z")
How many types of data goes into one “data point”? I assume 5 (the date and 4 numbers for the candle)? ---
**Author:** ![zalewskicompany](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/zalewskicompany/32/38721_2.png) [@zalewskicompany](https://community.glideapps.com/u/zalewskicompany)\ **Post date:** [February 11, 2022, 6:56am UTC](https://community.glideapps.com/t/candlestick-charts-how-to-make/38339/5 "2022-02-11T06:56:06Z")
Yes, 5 ---
**Author:** ![Darren\_Murphy](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/darren_murphy/32/47326_2.png) [@Darren\_Murphy](https://community.glideapps.com/u/Darren_Murphy)\ **Post date:** [February 11, 2022, 7:04am UTC](https://community.glideapps.com/t/candlestick-charts-how-to-make/38339/6 "2022-02-11T07:04:57Z")
That could be a bit of a challenge with quickchart, I think. The solid parts of the “candles” are easy enough, that’s just a floating bar chart. I’m just not sure how you’d get the vertical lines (the “wicks”). It _might_ be possible to combine two different chart styles to get that. Otherwise the only way I could think of to do it would be with annotations. But that would be quite a bit of work, I think. ---
**Author:** ![zalewskicompany](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/zalewskicompany/32/38721_2.png) [@zalewskicompany](https://community.glideapps.com/u/zalewskicompany)\ **Post date:** [February 11, 2022, 9:17am UTC](https://community.glideapps.com/t/candlestick-charts-how-to-make/38339/7 "2022-02-11T09:17:22Z")
Okay, then maybe a different approach to it. Is it possible to somehow embed the TradingView widget in the application? > **[Free Charting Library by TradingView](https://www.tradingview.com/HTML5-stock-forex-bitcoin-charting-library/?feature=technical-analysis-charts)** > > Free Charting Library for your website or mobile app. TradingView Charting Library comes with API to show your own data. Customizable and easy to install. ---
**Author:** ![Darren\_Murphy](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/darren_murphy/32/47326_2.png) [@Darren\_Murphy](https://community.glideapps.com/u/Darren_Murphy)\ **Post date:** [February 11, 2022, 10:07am UTC](https://community.glideapps.com/t/candlestick-charts-how-to-make/38339/8 "2022-02-11T10:07:24Z")
As long as they allow themselves to be embedded - and it looks like they do - then yes, that should be possible. ---
**Author:** ![zalewskicompany](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/zalewskicompany/32/38721_2.png) [@zalewskicompany](https://community.glideapps.com/u/zalewskicompany)\ **Post date:** [February 11, 2022, 10:13am UTC](https://community.glideapps.com/t/candlestick-charts-how-to-make/38339/9 "2022-02-11T10:13:35Z")
Where can I embed this code? What component can I use for this in the Glide? this is HTML5 ![Screenshot_2022-02-11-11-12-45-00](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/6/1/610dafcb944f1412ebf85c69c4f82a02078bc750.jpeg) ---
**Author:** ![Darren\_Murphy](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/darren_murphy/32/47326_2.png) [@Darren\_Murphy](https://community.glideapps.com/u/Darren_Murphy)\ **Post date:** [February 11, 2022, 10:22am UTC](https://community.glideapps.com/t/candlestick-charts-how-to-make/38339/10 "2022-02-11T10:22:12Z")
hmm, that looks like embeddable JavaScript. That won’t work in Glide. The way to embed external sites in Glide is via a [webview](https://docs.glideapps.com/all/topics/components/media/webview-component) component, but that only accepts a simple URL. To use the above, I think you would need to host it yourself, and then embed your hosted page in Glide. ---
**Author:** ![zalewskicompany](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/zalewskicompany/32/38721_2.png) [@zalewskicompany](https://community.glideapps.com/u/zalewskicompany)\ **Post date:** [February 11, 2022, 10:36am UTC](https://community.glideapps.com/t/candlestick-charts-how-to-make/38339/11 "2022-02-11T10:36:26Z")
Well, the problem starts when I have more shares - more charts and this list is dynamic, now there are such actions, in a week they will be different and I would have to manually update the websites (charts) hosted by me. The best solution at the moment seems to be [quickchart.io](http://quickchart.io), because in Google Sheets I can construct a link that will generate a chart - everything happens automatically. The problem is there is no candlestick chart there and I have to settle for a line chart. ---
**Author:** ![zalewskicompany](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/zalewskicompany/32/38721_2.png) [@zalewskicompany](https://community.glideapps.com/u/zalewskicompany)\ **Post date:** [February 11, 2022, 10:41am UTC](https://community.glideapps.com/t/candlestick-charts-how-to-make/38339/12 "2022-02-11T10:41:45Z")
I have yet to try this: > **[Online Candlestick Maker](https://online.visual-paradigm.com/charts/explore/candlestick-maker/)** > > Easily make impressive Candlesticks online, with candlestick templates and candlestick maker. Save time and effort. ---
**Author:** ![Darren\_Murphy](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/darren_murphy/32/47326_2.png) [@Darren\_Murphy](https://community.glideapps.com/u/Darren_Murphy)\ **Post date:** [February 11, 2022, 10:45am UTC](https://community.glideapps.com/t/candlestick-charts-how-to-make/38339/13 "2022-02-11T10:45:38Z")
> [@zalewskicompany](#): > > Well, the problem starts when I have more shares - more charts and this list is dynamic, now there are such actions, in a week they will be different and I would have to manually update the websites (charts) hosted by me. If you did go down the self-hosting route, then you could set it up in such a way that it accepts HTML parameters, which in turn are passed to the widget. Glide could pass these parameters as part of the URL. So in that sense, it could be made dynamic. > [@zalewskicompany](#): > > The best solution at the moment seems to be [quickchart.io](http://quickchart.io), because in Google Sheets I can construct a link that will generate a chart - everything happens automatically. > The problem is there is no candlestick chart there and I have to settle for a line chart. A candlestick might be possible with Quickchart, but I don’t think it will be an easy task. I had a bit of a play with it earlier today, and I couldn’t see any (obvious) easy way to do it. Somebody more experienced than me with Quickcharts might have more success. Just a side note - if you want these charts to be dynamic, then you should avoid constructing URL’s in your Google sheet, no matter which solution you settle on. Otherwise you’ll have delays with data sync between Glide and your Google Sheet. Instead, you should do all the work in Glide. ---
**Author:** ![zalewskicompany](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/zalewskicompany/32/38721_2.png) [@zalewskicompany](https://community.glideapps.com/u/zalewskicompany)\ **Post date:** [February 11, 2022, 11:09am UTC](https://community.glideapps.com/t/candlestick-charts-how-to-make/38339/14 "2022-02-11T11:09:18Z")
> [@Darren\_Murphy](#): > > If you did go down the self-hosting route, then you could set it up in such a way that it accepts HTML parameters, which in turn are passed to the widget. Glide could pass these parameters as part of the URL. So in that sense, it could be made dynamic. I have to try this ---
**Author:** ![zalewskicompany](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/zalewskicompany/32/38721_2.png) [@zalewskicompany](https://community.glideapps.com/u/zalewskicompany)\ **Post date:** [February 11, 2022, 11:41am UTC](https://community.glideapps.com/t/candlestick-charts-how-to-make/38339/15 "2022-02-11T11:41:24Z")
![Zrzut ekranu 2022-02-11 o 12.33.59~2](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/4/b/4b0fc8499f1fcfc0311bbef21f5c32e16d4fb659.png) Do I need upgrade to see anything? Whether external sites are blocking the webview component? ---
**Author:** ![Darren\_Murphy](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/darren_murphy/32/47326_2.png) [@Darren\_Murphy](https://community.glideapps.com/u/Darren_Murphy)\ **Post date:** [February 11, 2022, 11:58am UTC](https://community.glideapps.com/t/candlestick-charts-how-to-make/38339/16 "2022-02-11T11:58:11Z")
The error message pretty much says it all. The site you’re trying to embed doesn’t allow it. This is very common, as it’s generally considered a security risk. There is nothing that can be done on the Glide side. Your only option would be to contact the owner of the site and ask if they are willing to allow embedding. But I wouldn’t fancy your chances. ---
**Author:** ![zalewskicompany](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/zalewskicompany/32/38721_2.png) [@zalewskicompany](https://community.glideapps.com/u/zalewskicompany)\ **Post date:** [February 11, 2022, 12:00pm UTC](https://community.glideapps.com/t/candlestick-charts-how-to-make/38339/17 "2022-02-11T12:00:30Z")
Alright