# Get the data for this tickers from yahoo financeĭf = yf.download(tickers.Symbol. If you want just a single historic data point in an Excel cell then you can use this formula: ('TSLA', '') Which will put the close price of Tesla stock on into the current cell, as shown below: More historical formulas for single cells can be found here. # Read and print the stock tickers that make up S&P500 Single historical price in an Excel cell. Today = datetime.today().strftime('%Y-%m-%d')ĭf = yf.download(tickers,'',today, auto_adjust=True) CSV results in an error with no available data. In my eyes, both ways about doing this should work the same way effectively, so I'm very confused on how the second batch of code can execute so cleanly while the way using. ![]() What might be causing the error I am receiving? ![]() I have another file that appears to work in the same way and gives me the data flawlessly, which I will also include. CSV file, however I am having issues with yfinance pulling the data for some bizarre reason. Just trying to download historical closing prices for specific tickers found in a.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |