Import well-formatted daily OHLC data

You can use getSymbols() to import a well-formatted CSV. In this case, well-formatted means the file contains data for a single instrument with date, open, high, low, close, volume, and adjusted close columns, in that order. You might have noticed that this is the same format as getSymbols() returns when you download data from internet sources.

getSymbols() allows you to use a directory of CSV files as a source (like Yahoo Finance and FRED). In this exercise, you will be using AMZN.csv in your working directory. It contains some randomized Amazon.com data from the first half of 2002. You can use dir() to see the file in your working directory.

This exercise is part of the course

Importing and Managing Financial Data in R

View Course

Exercise instructions

Use getSymbols() to load AMZN.csv.
Look at the structure of AMZN.

Hands-on interactive exercise

Have a go at this exercise by completing this sample code.

# Load AMZN sourced from the csv
getSymbols("___", src = "___")

# Look at AMZN structure

Edit and Run Code