Loading Financial Data into Rapidminer

felix_wfelix_w MemberPosts:61Contributor II
edited December 2018 inHelp

Dear Rapidminer Community,

I went through some posts in the forum looking for a convenient way to load financial data (mainly stocks and indices) but I think there are only workarounds which work in some cases but nothing in general? The operators Yahoo Stock Data, Yahoo Historical Stock Data don't work? Or have I configured them wrongly? Also the workarounds from Scott and Thomas only work partly?

As most of these posts are almost a year old, I wanted to ask if there was already something new? An operator which allows to load financial data? Or any new (more convenient) workarounds to load data into Rapidminer?

Best regards

Felix

https://community.www.turtlecreekpls.com/t5/RapidMiner-Studio-Knowledge-Base/Real-Time-Financial-Data-via-Alpha-Venture-API-alternative-to/ta-p/41119

https://community.www.turtlecreekpls.com/t5/RapidMiner-Studio-Forum/Downloading-historical-financial-data-since-change-of-Yahoo-API/m-p/39145#M26819

Tagged:

Answers

  • Thomas_OttThomas_Ott RapidMiner Certified Analyst, RapidMiner Certified Expert, MemberPosts:1,761Unicorn

    @felix_wThe Fin/Econ extension is dead and probably won't ever be updated again. Yes, there are some non-elegant workarounds but I think@sgenzerposted something about using Quandl. Have a search for that.

    felix_w
  • hughesfleming68hughesfleming68 MemberPosts:323Unicorn

    In my opinion, the best way is to use R Execute. Lookup the libraries Quantmod and QuantTools which can also connect you to IQFeed if you need tick data. Quandl is also easy to set up. You may need to familiarize yourself with data frames and Posix dates and that is about it.

    Rapidminer + R is a formidable combination for financial analysis.

    Alex

    Thomas_Ott felix_w
  • felix_wfelix_w MemberPosts:61Contributor II

    Thank you for your replies! I will go with the easy version first and try to use quandl as I am not very familiar with R.

    Best regards

    Felix

    sgenzer
  • luc_bartkowskiluc_bartkowski MemberPosts:46Maven

    I use Alpha Vantage. They offer a simple web-based API. They offer also live data.

    A working daily data example RapidMiner process is available hereReal-Time-Financial-Data-via-Alpha-Vantage-API

    This RapidMiner model could be extended to intraday by extending the pivoting in the RM process. Intraday data includes an extra field (intraday timestep e.g. 15min, 10min, 5min, etc.) that has to be included in the process.

Sign InorRegisterto comment.