Knime for forex analysis

Just a note to let any other users know that I am working on using Knime for forex data analysis. There does not seem to be any other reasonable platform to do this, and although I'm going to have to work pretty much everything out on my own, I think it will be an interesting journey.

If there are others out there that have the same sort of interests, would be pleased to swap experience/modules etc.

Interesting post. I noticed the time series node in the poll. Have you voted?

I hate to reveal ignorance but what is "forex data analysis". From Jay's reply it sounds like some sort of time series data? We are working on a time series addon (mostly with financial applications at this point) - if you want we can share some of those prototypes with you if there are synergies. Disclaimer: early, experimental nodes!

It's financial (most likely) time series analysis of foreign exchange data.

What are the plans for the time series node? What kind of indicator computation did you have in mind? Will it handle regular and irregularly spaced data series?

I would be interesting in collaborating and helping out where I can.

Hi Jay, Berthold,

yes, did vote, and as you guessed for "time series"...

Briefly this is what I am thinking of doing (it might sound a bit obvious, but got to start somewhere):

Using hourly or daily candles use the mining capabilities of Knime to try to identify market setups, specifically interested in neural nets (because that's what I know) and the plotting and filtering capabilities to look for seasonal patterns and cross correlations.

In order to prepare the data, (because if I have understood Knime's strengths and weaknesses well, it is not designed for this task), I want to use my own in-house (open source) product, called "OpenRate" (http://www.openrate.de), which should perform the per record processing (e.g. to calculate the day of the year/week/month from the date in input).

Rgds

Ian

Hi Ian,

I am currently developing some new nodes in knime for the analysis of time series.

I have built a few preprocessing nodes already, like extracting sub-time series from the original time series, extracting one value per day, converting dates into a special time stamp knime type that unifies all date formats, and calculating moving average. It is not complete and not final, but if you think you could use it, i could pack it and send it to you.

At the moment I am building some graphical nodes, like time plots, bar charts and candlestick charts. In my next plans, there is embedding and recurrence plots, auto-regressive models, ARMA models, a few tchnical indicators, probably the FFT as well.

I can send you the nodes as soon as I produce them, but please take into account that this is all very preliminary work.

-- Rosaria

isparkes wrote:

In order to prepare the data, (because if I have understood Knime's strengths and weaknesses well, it is not designed for this task), I want to use my own in-house (open source) product, called "OpenRate" (http://www.openrate.de), which should perform the per record processing (e.g. to calculate the day of the year/week/month from the date in input).

Ian, sorry for the late reply but I wanted to remark on this a bit. KNIME is actually supposed to be very useful for data preparation and preprocessing but it sounds as if you don't think so? If you let us know a bit better what you are missing maybe we can join forces? From what I know, Rosaria has been talking offline to Jay about sharing her code - maybe this would be interesting for you as well?
OpenRate looks interesting but I must admit that I could not find a list of features or something similar?

At the KNIME UGM 2010 there was a presentation about FOREX trading using KNIME with the title "Optimizing Robot Traders for the Futures Market", given by Jan Pospisil. You can download it in the Past Events Section. Maybe that provides some more information.

Hi… I am completely new to KNIME and Machine Learning. The one thing attract me to this is possibility to use it for FOREX. But the last post is 10 years ago, is it due to no success or significance progress?

Well technical there are timeseries related nodes and also ML nodes as well as R, Python and Java Snippet nodes so it could be used

1 Like

Hello @hazmanch,

and welcome to KNIME Community!

Here is list of verified Components:
https://www.knime.com/verified-components
You’ll see there are ones for Time Series and one for Financial Analysis. Maybe you’ll find it useful in your work.

Also you revived a pretty old topic so I suggest for any new/specific question on FOREX analysis to open up a new topic :wink:

Br,
Ivan