Investigate yahoo finance blocking

[StephanAkkerman]

yf_info in yf_data.py seems to be blocking, is asynchronous=true really working?

[StephanAkkerman]

Maybe it takes longer if we give it more tickers?

[StephanAkkerman]

Made the function async for now

[StephanAkkerman]

https://stackoverflow.com/questions/75616231/how-to-get-daily-data-from-yfinance-asynchronously

[StephanAkkerman]

https://www.reddit.com/r/sheets/wiki/apis/finance/#wiki_yahoo_finance_api

[StephanAkkerman]

Could get the OHLCV data async like this:

from io import StringIO

import aiohttp
import pandas as pd


async def fetch(session, url, headers):
    async with session.get(url, headers=headers) as response:
        return await response.text()


async def get_stock_price(ticker):
    url = f"https://query1.finance.yahoo.com/v7/finance/download/{ticker}"
    headers = {
        "User-Agent": "Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/110.0.0.0 Safari/537.36 Edg/110.0.1587.57"
    }
    async with aiohttp.ClientSession() as session:
        response = await fetch(session, url, headers)
        df = pd.read_csv(StringIO(response))
        print(df)


import asyncio

asyncio.run(get_stock_price("NVDA"))