this is perfect timing, I am working on a project exactly like this with the Kucoin & FTX API and MySQL. I was using the same database logic that you used in the Stock Recommendation System & MySQL videos that you made earlier. Thank you for all the code you do man, its been invaluable to my programming learning curve.
Hello, please write to the trading view code that will find the impulse candle and give a signal. For example, if a candle formed on an hourly timeframe is 2 times larger than ordinary candles, it will give a signal that an impulse candle has been formed. Thanks
your vids are the most helpful on the net IMHO. The neat manipulations like adding dynamic names to columns in dataframes are the kind of little tricks that are difficult to learn as someone going it alone, self learning. So thanks for that. You talked about keeping this db updated a bit at the end .... any chance you could go into more detail there. I was unsure what you meant about ensuring you go by the last date.... also , would you consider utilizing a cron job or scheduler that could run daily (or some other interval) to continuously update the db ??? Anyway, keep up the great work. Seriously good stuff!!
Thanks a lot for your kind words griz, really appreciate them! Yeah I would set up a cronjob which is containing a script checking for the last date stored in the DB and then pull the data for the next day (or whatever time horizon you are considering). I will see what I can do to cover stuff like that in future videos.
@@Algovibes I second Griz's comments! Truly great content, and very appreciative of your knowledge. Did you end up making a video that addresses updating the db and using cronjob to help with the automation?
Funny how everytime i think of an idea, i see you made a video about it. You are awesome, keep on doing what you do. Actually for my project i used NoSQL database (mongodb) instead of mysql, it is waaay faster, you should consider it. My bot is now getting all the data realtime from binance and storing it to the db, and another bot handles indicators calculations, and will eventually handle trades. Hope all the best to youn good luck for the future.
thank you, it was so good to watch this tutorial, i really needed this, if it is possible to you please make another video and use 1m data to make for example 5 or 15 min table...
Thank you :-) That's great to read. I think this video should be what you are looking for: ruclips.net/video/HB1CLz0Z1NY/видео.html Let me know if that's helpful!
@@Algovibes Thanks! I just took the $14.99 membership! I'm trying to build a production level code to produce forecasts on exchange rate, and I want to get data from the web, store it nicely in an SQL, and produce the forecasts with different forecasting models. I want the code to be flexible to add new data and new predictors, hence I'm trying to switch to SQL from having always used flat files.
I personally would love a video on how to convert the Jupiter notebooks into a production level python project (or modules) that would be sharable on github. Sometimes I get a bit lost with the "good practices" on how to name the modules and the different setup files to have.
Sir, after using append and second time run , it create dublicate data in db file. How to remove dublicate data in bunch of data table. Pls make video on this.
Thank you so much for your generous info.. May I ask you how to write a program that retrieves one price every minute and place it in a database 24/7, viele dank
@@Algovibes thank you so much for replying to my question. Yes I saw your video, it is excellent. One thing that I wanted to know is how can I retrieve (interrogate) every minute a price from the Binance API? then take this price and store it into a database like SQL, then run an analytical program like a moving average or RSI then plot it. The key point that is really missing is the code to loop a code to go automatically onto the Binance API every minute retrieve the (current live price) and input it into an SQL or a Pandas dataframe and process it. This should run 24/7
Amazing video! Would you be able to do a tutorial on the Threaded Websokcet Manager for Binance, and how to use to pull real time data? Thanks in advance!
Hi, Algovibes... I'm not sure if you made a video or any instructions on how to update the database (I'm using mariadb) yet... It would be great if you did. Thanks! Marc
Algovibe, I've receive what seems to be a scammer's note using 'Algovibes" and a hidden Phone number... If not you then it would be good to advise people of this
I am getting those bot comments frequently. I am trying to moderate it, but for every deleted comment 2 new ones are coming up. Anyhow thanks for letting me know and be sure that I am doing my best to battle that. Regarding the DB update: Check out my Stock recommendation playlist. I am quite sure I covered it there.
Hi algovibes, as always great content! I appreciate that you give your valuable knwoledge for free to the community! Could you als do video how to create a own server to run the algo strategies? Best regards from stuttgart
@@Algovibes Hi algovibe, thanks for the link. In fact, I watched the video and I looked at GCP. GCP is paid, so I wanted to ask you if you have server solutions that you might host yourself?
![How to Manage a Database with Python, Pandas & SQL - UPDATE a DB professionally [DO NOT SKIP THIS!]](http://i.ytimg.com/vi/WqXknI1kql8/mqdefault.jpg)
![How to Manage a Database with Python, Pandas & SQL - UPDATE a DB professionally [DO NOT SKIP THIS!]](/img/tr.png)
![INTRADAY Trading Strategy on CRYPTOcurrencies implemented in Python [highly recommended to watch]](http://i.ytimg.com/vi/xy4gpC4rCZ8/mqdefault.jpg)
![How to LIVE ANALYZE the WHOLE Crypto Market [OVER 300 COINS] using Python, WS & a pinch of SQL](/img/1.gif)
this is perfect timing, I am working on a project exactly like this with the Kucoin & FTX API and MySQL.
I was using the same database logic that you used in the Stock Recommendation System & MySQL videos that you made earlier.
Thank you for all the code you do man, its been invaluable to my programming learning curve.
Awesome. Thanks a lot for your comment man. Appreciate it!
Hello, please write to the trading view code that will find the impulse candle and give a signal. For example, if a candle formed on an hourly timeframe is 2 times larger than ordinary candles, it will give a signal that an impulse candle has been formed. Thanks
Great series, like the focus on infrastructure, more episodes would be great
Thanks a lot for your suggestion man
your vids are the most helpful on the net IMHO. The neat manipulations like adding dynamic names to columns in dataframes are the kind of little tricks that are difficult to learn as someone going it alone, self learning. So thanks for that. You talked about keeping this db updated a bit at the end .... any chance you could go into more detail there. I was unsure what you meant about ensuring you go by the last date.... also , would you consider utilizing a cron job or scheduler that could run daily (or some other interval) to continuously update the db ??? Anyway, keep up the great work. Seriously good stuff!!
Thanks a lot for your kind words griz, really appreciate them!
Yeah I would set up a cronjob which is containing a script checking for the last date stored in the DB and then pull the data for the next day (or whatever time horizon you are considering).
I will see what I can do to cover stuff like that in future videos.
@@Algovibes I second Griz's comments! Truly great content, and very appreciative of your knowledge. Did you end up making a video that addresses updating the db and using cronjob to help with the automation?
Funny how everytime i think of an idea, i see you made a video about it.
You are awesome, keep on doing what you do.
Actually for my project i used NoSQL database (mongodb) instead of mysql, it is waaay faster, you should consider it.
My bot is now getting all the data realtime from binance and storing it to the db, and another bot handles indicators calculations, and will eventually handle trades.
Hope all the best to youn good luck for the future.
Thanks a lot for your comment and sharing your ideas tahar. Appreciate it!
thank you, it was so good to watch this tutorial, i really needed this, if it is possible to you please make another video and use 1m data to make for example 5 or 15 min table...
Thank you :-) That's great to read. I think this video should be what you are looking for:
ruclips.net/video/HB1CLz0Z1NY/видео.html
Let me know if that's helpful!
Hi Algovibes, do you have a website or somewhere where all your scripts are available?
Hey Ernest,
I got you covered! Get access to the notebooks here:
ruclips.net/channel/UC87aeHqMrlR6ED0w2SVi5nwjoin
@@Algovibes Thanks! I just took the $14.99 membership! I'm trying to build a production level code to produce forecasts on exchange rate, and I want to get data from the web, store it nicely in an SQL, and produce the forecasts with different forecasting models. I want the code to be flexible to add new data and new predictors, hence I'm trying to switch to SQL from having always used flat files.
I personally would love a video on how to convert the Jupiter notebooks into a production level python project (or modules) that would be sharable on github. Sometimes I get a bit lost with the "good practices" on how to name the modules and the different setup files to have.
Sir, after using append and second time run , it create dublicate data in db file. How to remove dublicate data in bunch of data table. Pls make video on this.
Thank you so much for your generous info.. May I ask you how to write a program that retrieves one price every minute and place it in a database 24/7, viele dank
Hey Philippe, I think my newest video goes in exactly that direction. Be invited to check that out and let me know if you have any more questions.
@@Algovibes thank you so much for replying to my question. Yes I saw your video, it is excellent. One thing that I wanted to know is how can I retrieve (interrogate) every minute a price from the Binance API? then take this price and store it into a database like SQL, then run an analytical program like a moving average or RSI then plot it. The key point that is really missing is the code to loop a code to go automatically onto the Binance API every minute retrieve the (current live price) and input it into an SQL or a Pandas dataframe and process it. This should run 24/7
Great😊
Thanks buddy!
How do we design to keep both spot price and futures price in the same database? Thank you very much for your video.😊
Thanks a lot Einstom. You just need to scrape both prices and create 2 different tables.
any difference in performance compared to SQlite?
Good question! My guess would be Sqlite is slightly faster but I have no qualified opinion on that.
Nice, now we can put data in , how can we read data from this db now ? Thnx.
Hi Eliot,
I have covered pulling the data in the end of the video.
Cheers
thx bro its perfect
Thanks buddy. Nice Name 🐗
Amazing video! Would you be able to do a tutorial on the Threaded Websokcet Manager for Binance, and how to use to pull real time data? Thanks in advance!
Thanks a lot Raghav,
I think I have covered that roughly 1-2 years ago. Be invited to browse through the cryptobot playlist
Hi, Algovibes... I'm not sure if you made a video or any instructions on how to update the database (I'm using mariadb) yet... It would be great if you did. Thanks! Marc
Algovibe, I've receive what seems to be a scammer's note using 'Algovibes" and a hidden Phone number... If not you then it would be good to advise people of this
I am getting those bot comments frequently. I am trying to moderate it, but for every deleted comment 2 new ones are coming up. Anyhow thanks for letting me know and be sure that I am doing my best to battle that.
Regarding the DB update: Check out my Stock recommendation playlist. I am quite sure I covered it there.
Wow... exactly what I wanted to do... I was using .csv files but they are getting too big... Thanks again for a n other super useful video
Thanks a ton Marc
Hi algovibes, as always great content! I appreciate that you give your valuable knwoledge for free to the community!
Could you als do video how to create a own server to run the algo strategies? Best regards from stuttgart
Hello Chef! 👨🍳
I have done cloud deployment e.g. here, maybe that's something you could be looking for:
ruclips.net/video/mDNIAkEZChg/видео.html
@@Algovibes Hi algovibe, thanks for the link. In fact, I watched the video and I looked at GCP. GCP is paid, so I wanted to ask you if you have server solutions that you might host yourself?