Moving Average (Simple exponential to use current day)

[rafante]

Hello,

I’m new to the forum and Knime and need a little bit of direction.

I have two columns, date (String) and close (D), and want to take the simple exponential moving average of the close value. I’m unable to calculate the current/latest day’s moving average (it just shows as the close value). Is this how the node works? how would I be able to calculate the moving average of the current/latest moving average?

Appreciate the help!

[rfeigel]

Welcome to the Forum @rafante
You’re more likely to get help if you upload your data.

[rafante]

KNIME_project3.knwf (26.9 KB)
Thanks for the heads up! this is what i’m working on right now.

i feel that there it’s similar to this though i cannot replicate the solution.

Moving average of closing price for securities

Can you share a dataset with an (anonymised) example? From what you explain honestly that is what Moving Average with a Window Size of 28 should do. You may have to use the Moving Average node inside of a loop (Group Loop Start Node) and you will have to make sure that the data you pass into that loop has been sorted first by stock, second by date. The Moving Average Node simply goes backwards (or in your case also forward) 28 rows from the current row - it doesn’t make any checks whether the pr…

[rfeigel]

I’m not an expert on this, but I think you need to reorder the data so the most recent data is at the bottom.
KNIME_project3.knwf (102.2 KB)

Example of Moving Average and Aggregation – knime

[rafante]

amazing this did the trick! thank you

[rfeigel]

Glad to be of help. Please mark “solved”