data fetching for indian stock

[drakhsin]

Hi,
Can you help me with a python code to get following data in excel sheet.
The input excel file has name of tickers of Indian stocks, file name stocks.xlsx
Following data required in output excel file name stocks_output.xlsx
both files are attached

[Pedroski55]

Where do you want to get data from?

Maybe you want to webscrape some Indian stocks and shares webpage?

If that is the case, provide a link and post the question in the forum "webscraping" perhaps? Doesn't sound too difficult for experienced "scrapers"!

[drakhsin]

Where do you want to get data from?

Maybe you want to webscrape some Indian stocks and shares webpage?

If that is the case, provide a link and post the question in the forum "webscraping" perhaps? Doesn't sound too difficult for experienced "scrapers"!

to get Data from Yahoo finance

[noisefloor]

Hi,

so what's the specific problem? Which code do you have? Please show here. Or is you expectation that somebody writes you code custom-tailored for your requirements for free?

Regards, noisefloor

[drakhsin]

Hi,

so what's the specific problem? Which code do you have? Please show here. Or is you expectation that somebody writes you code custom-tailored for your requirements for free?

Regards, noisefloor

I am very new for codes.
I have no idea how to write a code.
So if you can write one it will be a very great of you
Thanks

[snippsat]

I am very new for codes.
I have no idea how to write a code.

Here a start,these tools are not hard to use,but you should learn some Python basic stuff to.
These day all LLM that are online are is capable to give same answer,so Forum like this don't get much traffic these days.

import yfinance as yf
import pandas as pd

# Choose a ticker
ticker = "ITC.NS"

# Get data for the last year (interval = 1 day)
data = yf.download(ticker, period="1y", interval="1d", auto_adjust=False)
print(data.head())
# To Excel
data.to_excel("itc.xlsx")

[Pedroski55]

Well, that's disappointing, I thought I would make a million dollars quickly, but all I get is an error:

import yfinance as yf
import pandas as pd

ticker = "ITC.NS"
data = yf.download(ticker, period="1wk", interval="1d", auto_adjust=False)

data is an empty dataframe!

Output:
[*********************100%***********************]  1 of 1 completed

1 Failed download:
['ITC.NS']: YFRateLimitError('Too Many Requests. Rate limited. Try after a while.')

How might I get around this error??

Trying after a while did not help.

EDIT: Think I know why:

As of November 1st, 2021 Yahoo’s suite of services will no longer be accessible from mainland China. Yahoo products and services remain unaffected in all other global locations. We thank you for your support and readership.

Even with VPN on I can't access yahoo finance! There goes my million dollars