Scribd
Upload
26 views1 page

Extracting Financial Data Using APIs

The document outlines a section of a course on Data Visualization for Business Analytics at Adelphi University, focusing on data extraction using financial APIs. It covers the definition of APIs and provides instructions for extracting financial and macroeconomic data using Yahoo Finance, Google Finance, FRED, and OANDA. Additionally, it includes specific tasks related to retrieving stock data and Consumer Price Index (CPI) data from various sources using the quantmod package in R.

Uploaded by

munyaomusyimi10
Copyright
© All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as DOCX, PDF, TXT or read online on Scribd
26 views1 page

Extracting Financial Data Using APIs

The document outlines a section of a course on Data Visualization for Business Analytics at Adelphi University, focusing on data extraction using financial APIs. It covers the definition of APIs and provides instructions for extracting financial and macroeconomic data using Yahoo Finance, Google Finance, FRED, and OANDA. Additionally, it includes specific tasks related to retrieving stock data and Consumer Price Index (CPI) data from various sources using the quantmod package in R.

Uploaded by

munyaomusyimi10
Copyright
© All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as DOCX, PDF, TXT or read online on Scribd

Adelphi University

DSC 682- Data Visualization for Business Analytics


03- Data Extraction in R
Learning Outcomes from this Part:
1. Using Financial APIs for Extracting Data
 Describe what is an API
 Using the following APIs: Yahoo Finance, Google Finance, FRED & OANDA to extract
financial/ macroeconomic data

Extracting Data Using APIs

1. What is an API?

2. This is how you can get some data and insights pertaining to
retirement investments, cryptocurrency investments, gold prices, etc.
All with a few lines of code. For a detailed introduction on the package,
please visit: [Link] Answer the following
questions: (please explain all the steps one by one)
(a) How do we get stock data from quantmod? Which 5 companies did
you use to extract their stock data? Please explain in detail.

(b)How do we pull FRED data from quantmod? Which 3 countries did


you use to extract their CPI data? Please explain in detail.

(c) How do we pull oanda data from quantmod? Please explain in detail.

You might also like