Problems extracting column array from historical stock price data

2 views (last 30 days)
I'm tring to extract the dates from historical stock price data for Amazon.
My understanding is
a = importdata('AMZN.csv');
date = a.data(end:-1:1,1)
should do the trick, however, it extracts column 2 instead.
This is also true if I insert extra columns at the start of the csv file. I added a copy of the last column into the first column, and running the same code as above now extracts column 3 - the same column as in my first attempt.
What am I doing wrong?
https://finance.yahoo.com/quote/AMZN/history/ (the link if someone wants to try for themselves)
  1 Comment
Sindar
Sindar on 19 May 2020
try readtable instead
But, if you're set on (or stuck with) importdata, try looking at a and a.data directly and see if you can figure out what's going wrong

Sign in to comment.

Answers (0)

Categories

Find more on Financial Toolbox in Help Center and File Exchange

Products


Release

R2019b

Community Treasure Hunt

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

Start Hunting!