Clever Geek Handbook

How to import stock bases using the Quandl package

I'm trying to import stock basics using the Quandl package, I have pulled some data using this line of code:

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

However, I don't understand how I can get fundamental data, not just price data. Any idea how to do this? Also, is there a way to pull out all the stems with the same line?

+3


source to share


3 answers


I got this line of code from the package maintainer. There was a typo in the documentation, so this is the correct syntax:



Quandl("RAYMOND/MSFT_COST_OF_REVENUE_TOTAL_Q", trim_start="2009-06-27", trim_end="2014-03-29")
+1


source


You will find all the basics on this site: http://www.quandl.com/c/stocks/aapl . Just click on the number (quaterly / anualy) and you will be directed to the data page. On the right is a button R

. Clicking on 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 does not have all the fundamental details like Bloomberg, Reuters, CapitalIQ.

+2


source


There might be a problem using different SEC codes to get comparable data for different companies, so Quandl hss recently provided a consistent set of tags that can be used for some of the more common data types. In addition to the links to Floo0, you can check http://www.quandl.com/help/api-for-stock-data#SEC-Harmonized-Data

+1


source






More articles:


All Articles