Bottom Page

Thread Rating:
  • 0 Vote(s) - 0 Average
  • 1
  • 2
  • 3
  • 4
  • 5
 Read csv file from Yahoo Finance
#1
I am trying use of url as below with error. But I tried url manually ok. Please advise. Thanks

import pandas as pd
import numpy as np
url = f'https://query1.finance.yahoo.com/v7/finance/download/X.TO?period1=1410148800&period2=1567915200&interval=1d&events=history&crumb=.ZKRNIaomp4'
a = np.array(pd.read_csv(url,skiprows=7,header=None))
Quote
#2
I got unauthorized error when tried to copy-and-paste the url provided. You probably being logged-in to your yahoo account, when tried to get the data manually?!
Quote
#3
You are absolutely right! I got the error after logging out Yahoo. It says "Unauthorized", "Invalid cookie".
Is there a way to work around this or any other python modules can do it? I would like to retrieve historical market data like below from the csv file and put them in a dataframe. Thanks.

Date Open High Low Close Adj Close Volume
9/10/2018 16121 16147.09961 16057.09961 16057.09961 16057.09961 200681100
9/11/2018 16042.29981 16111.7002 15975.79981 16094.29981 16094.29981 215647000
9/12/2018 16093.29981 16096.09961 15993.59961 16049 16049 266571000
9/13/2018 16059.2002 16071.2002 15987.2002 16001.7002 16001.7002 221711900
9/14/2018 15990.29981 16032.5 15981 16013.5 16013.5 194435900
9/17/2018 16046.5 16118 16045.29981 16082.29981 16082.29981 222709300
9/18/2018 16120.79981 16198.7002 16091.5 16196 16196 228914700
Quote

Top Page

Possibly Related Threads...
Thread Author Replies Views Last Post
  Can't read text file with pandas zinho 4 404 May-23-2019, 05:31 PM
Last Post: zinho
  read complex file with both pandas and not Diedro 1 417 Jan-29-2019, 05:26 PM
Last Post: Larz60+
  read from txt. file in certain manner SchroedingersLion 13 1,390 Aug-07-2018, 04:14 PM
Last Post: SchroedingersLion
  1 I cant read many stocks(list) with pandas-datareader from yahoo Davidii111 1 1,445 Dec-27-2017, 04:47 PM
Last Post: nilamo
  Downloading data from Yahoo finance Alberto 2 6,395 Jun-26-2017, 04:50 AM
Last Post: snippsat
  Need help in framing data read from wav file Vishweshkumar 1 1,408 Feb-10-2017, 01:45 PM
Last Post: sparkz_alot

Forum Jump:


Users browsing this thread: 1 Guest(s)