Stock Trading App Tutorial [Part 07] - Charting and Filtering

In this video, we embed a TradingView chart widget into our app to make it easy to visualize our price data. We then add a filter to our stock list to find stocks that recently closed at new highs. We then create a new table for strategies and stock_strategies. We add a button to apply a strategy to a given stock. In the followup video, we will apply the strategy to the stocks in this table.

[michaelstreck]

I was having a terrible week, but now I have THREE new videos to work through this weekend! Pure awesomeness, as always!!!!

[teslaonly]

Really good series! You should continue. There will definitely be more and more viewers coming in.

[ragecagegroves]

I seem to be having the same issue as Spoder- I can't seem to apply either Strategy. When i click the 'Apply Strategy' button, i get this error- {"detail":[{"loc":["body", "strategy_id"], "msg":"value is not a valid integer", "type":"type_error.integer"}]}. i have banged my head for a good few hours trying to figure it out. at 31:22 when you inspect the html it states Option Value 1 and Option Value 2 but mine does not? Seems to revert to the option value list from the index.html tab. Does anyone have any suggestions or know how/what got mixed up?

[simonlee]

Hi Larry, where can I find part 6 & 7 session in WordPress? It is no new post in your WordPress.

[michaelstreck]

At 20:49, I am getting get empty results on my webpage, I'm guessing because there are no db records for today's (Saturday's) date? How can we get results using the most recent "market hours" date on a weekend? Thank you!

[deezol]

Does anyone know how to run the query @20:38 in postgres rather than SQLite? thanks in advance

[SniperUSMC]

How would I put a selectable date in the filter? I work late on this and, spent too much time troubleshooting, had a DUH moment, then I finally realized the clock struck midnight and there wasn't any data to obtain current days "new_closing_highs". Besides, sometimes I may want to see what the new closing highs were a few days back.

This is getting me closer to what I would like to do. Great series!!!!

[ewaschenko]

At 6:15 you said you coded a chart in JS from scratch, which video was that?

[weapona]

for anyone watching on the weekends don't forget to create an if block for weekend review to move the cursor back to Friday

[mdelair]

Maybe you mention it in a future video, but what about removing a stock from a strategy? Ex. if you no longer believe DLB is an opening range breakout candidate, how can you remove that ticker from the opening_range_breakout page? Love the content Larry, been a ton of fun learning thus far!

[bekzodqodirov]

Thanks Larry for all your contests, and i have one question. How to put several chart in one page like i define strategy like openning range break out and want to see all the chart at the same page. Is ot possible with tradingview charting?

[SpoderFromSaturn]

im getting the error "{"detail":[{"loc":["body", "stock_id"], "msg":"field required", "type":"value_error.missing"}]}" on where it does apply_strategy, any idea on what could be causing this?

[omercaspi]

Is the strategy table related in a way to the filters?
Thanks so much for all the effort! Loving the tutorials :)

[SniperUSMC]

Ya know, you don't have to put all the code on your page. I actually get more out of it if I have to type the code myself, sometimes I make typos, which throws errors and causes me to have to troubleshoot the code to find the problem. So I learn more. Thanks for not publishing the code for me to copy and paste. No I'm not being a smart a$$ by saying this, I mean it.

Thank you very much!!!

[richardboreiko]

I've noticed that some of the closing prices in the chart don't match the closing prices of the data. Could that be because one or the other is using an Adjusted Close price?

[soulphish]

Loving the videos, but it is so hard to follow along when you are copying and pasting massive chunks of code, and I have to keep pausing and moving frame by frame so that I can copy down what you are pasting. Is there any update on the blog posts coming?

[pedropinto]

Hi, I'm trying to run the code but it is requiring to install python-multipart. It should be installed or maybe I'm doing something wrong?
Thank you in advance, great work.

[maksimsbogdanovs]

Hey, i need help! Can anybody who got this part right can help me? I stuck with this part. Help needed sine the rest of tutorials are not on webpage.

[dsadsadsadsadsa]

Does anyone else get {"detail":"Not Found"} when applying a strategy to a stock? When I am on the page for a stock I also still have 1 opening_range_breakout 2 opening_range_breakdown underneath the submit button!

[ajax]

Hello group, I 've tried troubleshooting on my own. Does anyone have a fix for

Execution finished with errors.
Result: database or disk is full
At line 1:
SELECT symbol, name, stock_id, max(close), date
FROM stock_price JOIN stock on stock_id = stock_price.stock_id
GROUP by stock_id
ORDER by symbol


I've deleted all of my temp files and have enough memory for this command