How to LIVE ANALYZE the WHOLE Crypto Market [OVER 300 COINS] using Python, WS & a pinch of SQL

แชร์
ฝัง
  • เผยแพร่เมื่อ 30 ม.ค. 2025

ความคิดเห็น • 71

  • @Algovibes
    @Algovibes  2 ปีที่แล้ว +2

    Keep exploring at brilliant.org/Algovibes/. Get started for free, and hurry-the first 200 people get 20% off an annual premium subscription.

    • @wirtschaftswissenschaften
      @wirtschaftswissenschaften 2 ปีที่แล้ว +1

      thank you so much. I love all your videos. I am learning python specially for business and stockmarket. i am german. sorry for my english. However. love your videos soooo much thank you so much. you helped me a lot

    • @Algovibes
      @Algovibes  2 ปีที่แล้ว +1

      @@wirtschaftswissenschaften Many thanks Monique. Appreciate your comment! Wie du wahrscheinlich unschwer an meinem Akzent erkennen konntest, bin ich auch deutschsprachig 🙂

    • @SP-db6sh
      @SP-db6sh 2 ปีที่แล้ว

      @Algovibes plz block all spamer viewer from these post & your channel...

  • @TheWiiDz
    @TheWiiDz 2 ปีที่แล้ว +5

    thank you so much, this has so much added value.
    very helpful for own projects. keep it up :)

    • @Algovibes
      @Algovibes  2 ปีที่แล้ว

      Thanks a lot mate. Awesome to read it adds value for you!

  • @blazzz13
    @blazzz13 2 ปีที่แล้ว +1

    I have been a full time trader for 10 years and recently I have started learning how to code for my business. Knowing how to trade *and* code is an invaluable skill and your videos are very helpful Thank you

    • @Algovibes
      @Algovibes  2 ปีที่แล้ว +1

      Awesome! Let me know if you look for something which you didn't find on the channel yet.

  • @nordineelm8805
    @nordineelm8805 ปีที่แล้ว +1

    The code line (at time 15:42) that imports data to sql .. does not work for me.. returns sequence of 1's

    • @nordineelm8805
      @nordineelm8805 ปีที่แล้ว +1

      Thnx .. for effort and the valuable amount of info easy explained ..

    • @Algovibes
      @Algovibes  ปีที่แล้ว

      Thank you mate. Can you elaborate on your problem?

  • @jamersinfo2685
    @jamersinfo2685 3 หลายเดือนก่อน +1

    Hi sir, sir how to compute the value of coins from the last 1 minute ago? I wanted to count how many times the coin price went down or and compare againts btc. its like finding a coin that has contrast price direction with btc.

    • @Algovibes
      @Algovibes  2 หลายเดือนก่อน

      very interesting question! Will see that I cover it in an upcoming vid. Thanks for the suggestion

  • @mrnobody2492
    @mrnobody2492 ปีที่แล้ว +1

    your wisdome is great keep up the great work !

    • @Algovibes
      @Algovibes  ปีที่แล้ว

      Thanks Buddy :-)

    • @mrnobody2492
      @mrnobody2492 ปีที่แล้ว

      @@Algovibes can you make a video where you install the libary talib for pycharm for Python 3.11.3 im struggeli g, Probably many user would be interessted

  • @rajeevmenon1975
    @rajeevmenon1975 2 ปีที่แล้ว +1

    Your videos never fails to impart great content. Totally in awe. Looking forward to see your face as I feel you crossed the milestone for a face reveal.
    THANK YOU BROTHER

    • @Algovibes
      @Algovibes  2 ปีที่แล้ว

      Thank you my man! Face reveal at 100k 😁

  • @JalilAsghar
    @JalilAsghar 2 ปีที่แล้ว +2

    Always excellent and very informative lectures, thank you.

    • @Algovibes
      @Algovibes  2 ปีที่แล้ว

      Thanks a ton Jalil!

  • @barneyharper8749
    @barneyharper8749 2 ปีที่แล้ว +4

    Ich liebe deine Videos. Top Mann

    • @Algovibes
      @Algovibes  2 ปีที่แล้ว

      Danke mein bester!

  • @assafcohen3173
    @assafcohen3173 2 ปีที่แล้ว +1

    Very good video, keep it up!

    • @Algovibes
      @Algovibes  2 ปีที่แล้ว

      Thanks a ton buddy

  • @thesilentcitadel
    @thesilentcitadel 2 ปีที่แล้ว +2

    Would it be possible to limit the number of entries in the database tables for each token to only an hour or so?

    • @wickedgummybear3104
      @wickedgummybear3104 2 ปีที่แล้ว +1

      You can create a function based on either real time, candle time, or just a ticker check, that checks the N amount of rows in the database and delete the first N rows. That will keep the database from growing out of control.

    • @Algovibes
      @Algovibes  2 ปีที่แล้ว

      Good suggestion from wicked gummy! An even better one would be to implement a delete query which is managing that you only have the rows for the last N minutes.

  • @groundingtiming
    @groundingtiming 2 ปีที่แล้ว +1

    Hello, by any chance do you have an official github repo ?

    • @Algovibes
      @Algovibes  2 ปีที่แล้ว +1

      Hi mate, even better: The possibility to both get access to the source code and supporting the channel by becoming a channel member here:
      th-cam.com/channels/87aeHqMrlR6ED0w2SVi5nw.htmljoin

    • @groundingtiming
      @groundingtiming 2 ปีที่แล้ว

      @@Algovibes Hi mate, i dont understand and is new to this channel area. Do you have a page that says what it consist of?

  • @tudatostrader
    @tudatostrader 2 ปีที่แล้ว +1

    Hey hey hey! Does the code access membership include the discord server as well? Great work btw.

    • @Algovibes
      @Algovibes  2 ปีที่แล้ว

      Hi Marcel,
      Yes! Looking forward to welcome you :-)

  • @yellowboat8773
    @yellowboat8773 2 ปีที่แล้ว

    Complete newbie here, but why do you put the data into an sql table? Why can't you just store the data in python itself? Is it a data size problem? Or even better just read the data direct from the stream and not store it at all? Would love a pro to learn me 🙂

  • @contactshahpriyank
    @contactshahpriyank 2 ปีที่แล้ว +3

    Awesome video. Really good quality material. I do code all your videos out from start to finish. Great content. Please post the Arbitrage ccxt video where you can analyze all the markets at the same time for all the coins.

    • @Algovibes
      @Algovibes  2 ปีที่แล้ว

      Thanks a ton mate :-) Really appreciate your comment!

  • @wickedgummybear3104
    @wickedgummybear3104 2 ปีที่แล้ว

    I might have missed it but isn't it better to check the ticker message for a true candle close before putting it in the DB? Because the candles from binance do have that, I think the character is 'x' .. this way you wont end up with a huge amount of useless millisecond ticker data in your database.

  • @mk-fg3ed
    @mk-fg3ed 2 ปีที่แล้ว +1

    HI. Ich habe dir eine Nachricht geschrieben & der Link zum Discord ist abgelaufen :))

  • @fredrickmahinay607
    @fredrickmahinay607 2 ปีที่แล้ว +1

    Can I use pycharm for this?

    • @Algovibes
      @Algovibes  2 ปีที่แล้ว

      Sure! Whatever IDE / environment suits you best.

  • @daniel3897
    @daniel3897 2 ปีที่แล้ว +1

    Great video! I was wondering if would be possible something like: "How to LIVE ANALYZE the WHOLE S&P 500 STOCK MARKET INDEX [OVER 500 COMPANIES] using Python, WS & a pinch of SQL". 😁 Just wondering, no clue if it's even possible. Thanks a lot Algovibes, I've been learning a lot with your videos.

    • @Algovibes
      @Algovibes  2 ปีที่แล้ว +1

      Thanks a lot Daniel! Yea I was actually doing that quite a lot in the past (roughly 2 years ago on this channel). Check out e.g. the Python for Finance playlist and you will find what you are looking for. If not, please let me know and I'll see what I can do.

    • @daniel3897
      @daniel3897 2 ปีที่แล้ว +1

      @@Algovibes hey mate, I love it. I'll check that out and let you know for sure if I can't find the content. Thanks a lot for the work you've been putting up for the community! :) Cheers

  • @paulpaulsen3357
    @paulpaulsen3357 2 ปีที่แล้ว +1

    Nice vid again, yes please how to work with timestamp have a good day

    • @Algovibes
      @Algovibes  2 ปีที่แล้ว

      You too man. Thanks a lot :-)

  • @arunmohan36
    @arunmohan36 2 ปีที่แล้ว +1

    Thank you bro 😍

    • @Algovibes
      @Algovibes  2 ปีที่แล้ว

      Thank YOU for watching and leaving a comment :-)

  • @lorenzobaggi161
    @lorenzobaggi161 2 ปีที่แล้ว +1

    Goat

    • @Algovibes
      @Algovibes  2 ปีที่แล้ว

      🐐😁 Thanks buddy

  • @OPPACHblu_channel
    @OPPACHblu_channel 2 ปีที่แล้ว +1

    Super tutorials thx for your work
    PC: when i try to use global variable like in this video all doing perfectly in jupiter notebook, but if i exact same code in regular *.py file got an error
    NameError: name '*variable name*' is not defined what is the problem might be? thx

    • @Algovibes
      @Algovibes  2 ปีที่แล้ว +1

      Thx for watching my stuff buddy. Using Jupyter or .py doesn't make a difference for the global variable definition. There has to be something else wrong. I guess you are not getting the server message so that the global variable is never defined. Can you double check that?

    • @OPPACHblu_channel
      @OPPACHblu_channel 2 ปีที่แล้ว

      @@Algovibes thx for your reply, i have received message and they are printing out with no issue. But when i define global variable in this function and try to use it out of the function scope, got this error. Anyways as i will store the messages from stream to db, and retrieve, think the is no big problem. But the fact this global variable didnt work, make me questions...

    • @OPPACHblu_channel
      @OPPACHblu_channel 2 ปีที่แล้ว

      @@Algovibes
      def on_message(ws, message):
      global qwe
      qwe = message['k']
      Print(message['k'])

  • @regioncelestial
    @regioncelestial 2 ปีที่แล้ว +3

    so little views and very little likes. This information you're sharing with the community is really gold for learning purposes. This is a really amazing starting point, from here everyone can use their imagination to take advantage of this information. Thank you so much from a third world country.

    • @Algovibes
      @Algovibes  2 ปีที่แล้ว +1

      Thanks buddy. Appreciate your comment!
      Yea, I am currently having a hard time getting significant traction on YT but I will not give up :-)
      People like you are a tremendous help, Thank you.

  • @barneyharper8749
    @barneyharper8749 2 ปีที่แล้ว +1

    löschst du ab und an videos? ich suche das video, wo du zeigst, wie man mit binance ein rest-api setup erstellt. warum websocket statt REST?

    • @Algovibes
      @Algovibes  2 ปีที่แล้ว

      Nein. Alle videos sind noch online. Check mal die Cryptobot playlist.

  • @jpngoncalves
    @jpngoncalves 2 ปีที่แล้ว +2

    Boa noite! O que era interessante em temos de python seria um aglomerador de notícias de stocks e crypto. Estou a falar de rss de sites de referência, benzinga, cnbc, bloomberg, seeking alpha entre outros. Abraço de 🇵🇹

    • @Algovibes
      @Algovibes  2 ปีที่แล้ว +1

      Thanks buddy. Hugs back ❤️ Awesome suggestion!

  • @barneyharper8749
    @barneyharper8749 2 ปีที่แล้ว +1

    Richtig nice wäre als ein Projekt ein arbitrage-bot. 3 börsen per api einbinden und wenn's mal richtig zur Sache geht im Markt....

    • @Algovibes
      @Algovibes  2 ปีที่แล้ว

      Wird kommen :-)

  • @harvardh1769
    @harvardh1769 2 ปีที่แล้ว +2

    Please make a Discord Server :)

    • @harvardh1769
      @harvardh1769 2 ปีที่แล้ว +1

      Also Thanks for the great content

    • @Algovibes
      @Algovibes  2 ปีที่แล้ว +3

      Thanks mate! Great news:
      The Discord server is already up!
      Be warmly invited to join here:
      th-cam.com/channels/87aeHqMrlR6ED0w2SVi5nw.htmljoin

  • @breakoutgaffe4027
    @breakoutgaffe4027 2 ปีที่แล้ว +1

    Nice

    • @Algovibes
      @Algovibes  2 ปีที่แล้ว

      Thanks for your comment mate :-)

  • @isabellastewart5855
    @isabellastewart5855 2 ปีที่แล้ว +4

    The fact is, BTC is the future and the question most people ask themselves is - if this is right time to invest? I feel those who would allow the market dynamism to determine when to trade or not are either new in this space in general or probably just naive, the sphere have seen far worse times than this, enlightened traders continue to make good use of the dip and pump even acquiring more equities towards trading sessions, I’d say that more emphasis should be put into trading, since it is way profitable than holding. Trading went smooth for me as I was able to raise over 9 BTC when I started at 2.5 BTC in just 5 weeks of implementing trades with signals and insights from Jim Detterick, I would advise you all to trade your asset rather than hold for a future you aren’t sure about.

    • @berniegarcia6593
      @berniegarcia6593 2 ปีที่แล้ว

      Jim Detterick helped me to understand technical analysis, now I can examine the current chart and predict which way the market will go, he is definitely the best pro trader I know...

    • @isabellastewart5855
      @isabellastewart5855 2 ปีที่แล้ว

      You can communicate with him on telegram with the user name below only.

    • @isabellastewart5855
      @isabellastewart5855 2 ปีที่แล้ว

    • @isabellastewart5855
      @isabellastewart5855 2 ปีที่แล้ว

      @`Dettericktrade.

    • @birgit1012
      @birgit1012 2 ปีที่แล้ว

      His technical analysis are grate. his interpretation/projections of the market is so accurate, Jim Detterick is one of t e best trader i know to follow for advise and daily signal.