Adj Close is read incorrectly by urlread

When I go to
'https://query1.finance.yahoo.com/v7/finance/download/mo?period1=641347200&period2=1588118400&interval=1d&events=history'
in my browesr, I get an excelsheet with multiple columns including close and adj close (the two columns are different for this stock)
But when I use MATLAB and type:
url= 'https://query1.finance.yahoo.com/v7/finance/download/mo?period1=641347200&period2=1588118400&interval=1d&events=history';
[temp, status] = urlread(url,'get',{'matlabstockdata@yahoo.com', 'historical stock'});
The close and adj close columns are identical (i.e. the adj close column is missing and the close column is repeated in its place).
This problem does not occur for all stocks. For example it works fine for
'https://query1.finance.yahoo.com/v7/finance/download/ba?period1=641347200&period2=1588118400&interval=1d&events=history'
but it does not work for
'https://query1.finance.yahoo.com/v7/finance/download/agnc?period1=641347200&period2=1588118400&interval=1d&events=history'
and
'https://query1.finance.yahoo.com/v7/finance/download/mo?period1=641347200&period2=1588118400&interval=1d&events=history'

2 Comments

Can anyone let me know why this started happening?
Or if you know of a solutiuon.
And for stocks like IBM and CVS nothing comes back with the MATLAB command (although if you just type the url address to your browser, you will get an spreadsheet with the data).

Sign in to comment.

Answers (0)

Categories

Find more on Financial Toolbox in Help Center and File Exchange

Asked:

on 29 Apr 2020

Commented:

on 29 Apr 2020

Community Treasure Hunt

Find the treasures in MATLAB Central and discover how the community can help you!

Start Hunting!