Financial Data Accessible from R – part III

I came across a new source of data which I think is really worth sharing: ThinkNum. It gathers around 2,000 sources of data but more importantly it allows the user to manipulate this data via functions and graphics and there is an R package available on CRAN. Interested readers can find a very good post exploring some of the functionalities here.

Source R Package Free Access Available on CRAN Package/Data URL
Yahoo, FRED, Oanda, Google Quantmod Yes Yes http://www.quantmod.com/
Quandl Quandl Yes Yes http://www.quandl.com/help/packages/r
TrueFX TFX Yes Yes http://rpubs.com/gsee/TFX
Bloomberg Rbbg No No http://findata.org/rbloomberg/
Interactive Broker IBrokers No Yes https://www.interactivebrokers.com/en/main.php
Datastream rdatastream No No https://github.com/fcocquemas/rdatastream
Penn World Table pwt Yes Yes https://pwt.sas.upenn.edu/
Yahoo, FRED, Oanda fImport Yes Yes http://www.rmetrics.org/
ThinkNum Thinknum Yes Yes http://thinknum.com/

Data Description

  • Yahoo: Free stock quotes, up to date news, portfolio management resources, international market data, message boards, and mortgage rates that help you manage your financial life
  • FRED: Download, graph, and track 149,000 economic time series from 59 sources
  • Oanda: Currency information, tools, and resources for investors, businesses, and travelers
  • Google: Stock market quotes, news, currency conversions & more
  • Quandl: Futures prices, daily. Quandl is a search engine for numerical data. The site offers access to several million financial, economic and social datasets
  • TrueFX: Tick-By-Tick Real-Time And Historical Market Rates, Clean, Aggregated, Dealer Prices
  • Bloomberg: Financial news, business news, economic news, stock quotes, markets quotes, finance stocks, financial markets, stock futures, personal finance, personal finance advice, mutual funds, financial calculators, world business, small business, financial trends, forex trading, technology news, bloomberg financial news
  • Interactive Broker: Interactive Brokers Group, Inc. is an online discount brokerage firm in the United States
  • Datastream: Datastream Professional is a powerful tool that integrates economic research and strategy with cross asset analysis to seamlessly bring together top down and bottom up in one single, integrated application
  • pwt: The Penn World Table provides purchasing power parity and national income accounts converted to international prices for 189 countries/territories for some or all of the years 1950-2010
  • Thinknum: Thinknum brings financial data from a variety of useful sources together on one platform. We use this data to develop applications

Package Detail

  • Quantmod: Specify, build, trade, and analyse quantitative financial trading strategies
  • Quandl: This package interacts directly with the Quandl API to offer data in a number of formats usable in R, as well as the ability to upload and search
  • TFX: Connects R to TrueFX(tm) for free streaming real-time and historical tick-by-tick market data for dealable interbank foreign exchange rates with millisecond detail
  • Rbbg: Handles fetching data from the Bloomberg financial data application
  • IBrokers: Provides native R access to Interactive Brokers Trader Workstation API
  • rdatastream: RDatastream is a R interface to the Thomson Dataworks Entreprise SOAP API (non free), with some convenience functions for retrieving Datastream data specifically. This package requires valid credentials for this API
  • pwt: The Penn World Table provides purchasing power parity and national income accounts converted to international prices for 189 countries/territories for some or all of the years 1950-2010
  • fImport: Rmetrics is the premier open source software solution for teaching and training quantitative finance. fImport is the package for Economic and Financial Data Import
  • Thinknum: This package interacts directly with the Thinknum API to offer data in a number of formats usable in R

 

7 Comments

  1. jangorecki says:

    Any hint which of the mentioned packages can return monthly data?

    • The R Trader says:

      Thank you for reaching out.
      I think you should focus on the kind of data you’re looking for and use R capabilities to turn whatever you need into monthly data.
      There are numerous functions within R to do this. One that I use on a regular basis is to.period in the xts package. I let you have a look at the documentation 🙂

      I hope this helps

  2. Shahini says:

    Please let me know from where could I import the Data streams in R tool for clustering. Who could give me a dynamic data stream

  3. Jack says:

    Hey you guys take a peak at barcharts free api… It includes futures too and I’m pretty sure its the only free service that includes futures… http://freemarketdataapi.barchartondemand.com

  4. TIm says:

    The quandl package url should be https://www.quandl.com/tools/r

    Not sure the Thinknum package still works, as their API page is removed, and the example function doesn’t work

    Thinknum(“total_revenue(goog)”)
    # Error in Thinknum(“total_revenue(goog)”) :
    # Requested Expression does not exist.

Leave a Reply