Logo Questions Linux Laravel Mysql Ubuntu Git Menu
 

How to import fundamentals for stocks by using Quandl package

Tags:

r

quandl

I'm trying to import fundamentals for stocks by using Quandl package,I pulled some data by using this line of code:

mydata <-Quandl("WIKI/AAPL", collapse="quarterly")

However, I don't understend how can I get fundamentals data and not just the price data. Any Idea how to do that? Also, Is there a way to pull all fundamentals with the same line?

like image 596
mql4beginner Avatar asked Oct 01 '22 01:10

mql4beginner


2 Answers

On this site you find all the fundamentals: http://www.quandl.com/c/stocks/aapl. Just click on the figure (quaterly/anualy) and you will be directed to a page with the data. There is an R button on the right. Clicking it will give you the R-Code.

Example: Gross-Profit: http://www.quandl.com/SEC/AAPL_GROSSPROFIT_Q-APPLE-INC-AAPL-Quarterly-Gross-Profit

Quandl("SEC/AAPL_GROSSPROFIT_Q", 
       trim_start="2009-06-27", 
       trim_end="2014-03-29")

But from my understanding quandl do not have all the fundamental-details like Bloomberg, Reuters, CapitalIQ.

like image 143
Rentrop Avatar answered Oct 03 '22 01:10

Rentrop


There can be an issue needing to use different SEC codes to obtain comparable data on different companies so Quandl hss recently provided a harmonized set of tags which can be used for some of the more common data types. In addition to Floo0 references, you might want to check out http://www.quandl.com/help/api-for-stock-data#SEC-Harmonized-Data

like image 25
WaltS Avatar answered Oct 03 '22 02:10

WaltS