Storing live data in database using python part 7

In this video we have seen how to make a database and then how to store the data realtime in the database

Book your spot for the summit 2022

#quant
#pythonforbeginners
#finance
#algotrading
#quanttrader
#python
#api
#cqf
#cfa
#financialanalysis
#financialanalyst

[deepakchaudhari]

Thank you Sirji, Please always share the code, also please let us know why we are using Db and Saving tick data, why we cannot use tick data to build indicators, please make one complete code from start to end example 3 supertrend, then buy sell function with trailing stoploss.

[denizaltay]

Can you succesfully achieve results without hitting any bottleneck issue in ingesting into db?

[hariprasad-zqbp]

Pls make video, To avoid repeated data or duplicate data and how to get tick data on change and store to db and also without missing any ticks and handle efficiently for two tokens

[anuInbetweener]

Please tell me how to save live data temporarily in a python variable, of about only previous 1 minute . per second data in a variable to easy access and compute?

[milindsonawane]

Please share video to save Espresso API websocket tick prices to sql database. I will remain thankful for the same. 🙏

[munivoltarc]

Hi, can you do this for new FYERS APIV3 so that many will learn from you. Thank you

[henilalagiya]

Question : Why here we are getting 1 price or ticker every second only. i mean why we are not able to get data in milisecond.

[icryps]

How to get 15 min OHLCV data and save it to csv? Also request you if possible make a video on Options data and options auto trading.

[jojokispotta]

if primary key is the timestamp, and if we receive multiple ticks of data per second, then the database wont accept the data. Won't this be incorrect data?

[nithinmohan]

Hi. Your videos where really helpful. I don't know sql. Is it possible to store the data as csv or json format in a file instead of using sql? What is the advantage of using sql?

[omkarreddy]

Sir, could you please make a video on live algo trading using a trading strategy

[phaniraghavendraksv]

Hi, how to print this using django template view. Will this work the same?

[oumkaarrs]

Plz read full comment.
Plz Plz Plz guide, how can I record "LIVE" Nifty / Bank Nifty INDEX OR OPTION Open High Low Close "LIVE" Data IN EXCEL.
Suppose I want Data for 45000 PE IN FOLLOWING FORMAT

A B C D E
Time Open HIGH LOW CLOSE
1 9:18 100 112 88 104
2 9:17 103 109 76 88
3 9:16 90 119 78 119
4 9:15 120 138 120 135

Will it be possible to print data so that latest data will be printed on Row number 1 ( i.e. on A1 B1 C1 D1 & E1 ) and after new data comes the old data keeps shifting down in excel.

[ravindralonkar]

Hi Bro, I have tried to store ticks of 50 stocks, after saving few tick stuck and not saving data, even saved data is also not saved at real time save at very late

[keelanur]

will this work in free version or paid