Hello Jothi, i tried your support and resistance python program to load it to mysql database using python. all is fine but output shows as 0 rows returned whenever i try to run query in mysql. what am i missing? pls help
Hello Nikhil, Make sure you have these checked. 1. While inserting data MySQL was running. 2. dataframe had data or not. 3. MySQL connection was established correctly or not. Most probably the root cause of this problem should be in the above.
@@jothiprakashanandan Thanks for the revert, i tried what you have suggested but in vain. dataframe is perfect, downloading the same in csv file is perfect. But, In the result grid in mysql, all columns such as SYMBOL, OPEN, HIGH, LOW, CLOSE, Pivot are reflecting, but rows are blank. :/
sir, after downloading csv only 3 link is opened on which two link to download with small difference in (csv=True). but when i try this is not shown. if possible please save this programme in github page so that anyone can easily use it. Thank you
hi i recently tested it out in nse but the request is running indefinetly, i had to interrupt and restart kernel after 30 mins. tried with postman too but its also taking long in web version. is nse interrupting scrapping or am i missing something
I was able to download OHLC data from NSE using Bhavcopy but I am not able to adjust the price. Do you have any idea how we can adjust the prices for dividend, splits and bonuses? Request you to create a video for it once we have OHLC data for say NSE 200 or something.
It's a Jupyter notebook file. You need to open in a Jupiter notebook environment. But point taken, I'll upload the Python file and share the link in the description.
![Create your own Finance DataBase with Python & SQL [perfect for backtesting trading strategies]](http://i.ytimg.com/vi/5bUn-D4eL4k/mqdefault.jpg)
Very Useful Sir do more videos it helps me most
Excited for a next video
Thanks, Sundar.
Very Good Content and efforts @Jothi, please create a video for download the bhav copy from NSE by python
Sure. Will do.
And today it is posted... Gr8 efforts.
@@rgdphome8974Thank you!
Great Mr JP Anandan Ji ,
How to connect it to Amibroker?
Thank You.
sir how to get historical data for nifty 50 index and bank nifty index
Great Video Sir 👍
Please make video on algo trading.
Will do. Thanks for the feedback.
Hi Jothi , I tried to do the same but after 2-3 runs It started giving me Error Code : 403.
Could you please help me on this issue ?
can i get fundamental data for the stocks using python
I want to extract data in bulk for lots of symbol , is it possible if yes then how?
Hello Jothi, i tried your support and resistance python program to load it to mysql database using python. all is fine but output shows as 0 rows returned whenever i try to run query in mysql.
what am i missing? pls help
Hello Nikhil, Make sure you have these checked.
1. While inserting data MySQL was running.
2. dataframe had data or not.
3. MySQL connection was established correctly or not.
Most probably the root cause of this problem should be in the above.
@@jothiprakashanandan Thanks for the revert, i tried what you have suggested but in vain.
dataframe is perfect, downloading the same in csv file is perfect.
But,
In the result grid in mysql, all columns such as SYMBOL, OPEN, HIGH, LOW, CLOSE, Pivot are reflecting, but rows are blank. :/
@@NikhilShukla-bn3wr Seems like a commit issue from MySQL end. Let me check if I can replicate this.
Hi sir, can we scrape intraday price data as well ? Say for example 5 minute timeframe OHLC
You can convert the 1 second data to 5 minutes data using pandas. No need for additional data fetching.
hi bro
I need small help
Need class for python
Algo ungakita kathukanum
Epdi contact panrathu
sir, after downloading csv only 3 link is opened on which two link to download with small difference in (csv=True). but when i try this is not shown. if possible please save this programme in github page so that anyone can easily use it. Thank you
Is it possible in options open equal low
hi i recently tested it out in nse but the request is running indefinetly, i had to interrupt and restart kernel after 30 mins. tried with postman too but its also taking long in web version. is nse interrupting scrapping or am i missing something
The cookie must have expired. Each time you scrape data you have to update the cookie. NSE Cookies are very dynamic and changes each time.
yeah ok it worked thanks i hope this helpsa a lot of beginners@@jothiprakashanandan
informative, thanks !
Glad it was helpful!
I was able to download OHLC data from NSE using Bhavcopy but I am not able to adjust the price. Do you have any idea how we can adjust the prices for dividend, splits and bonuses? Request you to create a video for it once we have OHLC data for say NSE 200 or something.
Hi, i want to import nse data into Google sheets using python. Is it possible? If so please make a video
Sure, Vijay. Thanks for the idea. And yes it's possible.
Sir how to insert all nse equity data to database Pls help
Hello Bhojani, It's in the video after 30 minutes.
I want to learn python for trading, i m new to coding, what steps..?
Just follow along. You will get to know all the knowledge and tools needed to become a trader.
google drive file not working
It's a Jupyter notebook file. You need to open in a Jupiter notebook environment.
But point taken, I'll upload the Python file and share the link in the description.
Hello Sir,
I'm Sundar doing my Masters in Data Science final year.
Currently looking for internship to improve my career,Please help me Sir
Thank you
Hi Sundar, I'm working in Dell. If you find an intern position in the Dell Career portal, let me know.
I'll put in a referral for you.
Okay sir