Calculating Exponential Moving Average from comma text file

Question

1.00/5 (1 vote)

See more:

C#5.0

I need to get Exponential Moving Average and show it in datagridview
by all index and by single index

thank you

Posted 22-Dec-14 10:58am

myproject235

Updated 20-Feb-15 14:13pm

v12

Add a Solution

Comments

Tomas Takac 22-Dec-14 17:12pm

First, you need to separate out the code that calculates the EMA form the code which displays it in the grid. Secondly, this is too complicated, I looked on Wikipedia and calculating EMA isn't that complicated, seems to be pretty straightforward actually.

Tomas Takac 23-Dec-14 4:22am

I think I see your problem now, you want to calculate EMA for 3,5,...,100,200 days for each row, right? Well that's a lot of work, O(n^2) I believe. Anyway, you need to structure your code differently. First parse the input into a list of objects, then calculate EMA, then bind the resulting list to the grid. I'll be able to put that into an answer later on, but do not expect a complete solution from me or anybody else here.

1 solution

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

Maciej Los · Answer 1 · 2014-12-23T02:52:00

Solution 2

The main problem is that you operate on DataGridViewCells instead of data. I'd suggest to separate code for calculations from UI.

Steps to do:

Create custom class[^], let's say: CEM with public fields (Item, Data, Close, Sma, Ema).
Create List<CEM>[^] and provide method to load data into it.
Sort[^] List<CEM> on Date field
Calculate Sma and Ema fields. Use List<CEM> index[^] for calculations or use Linq[^] methods.
Finally, load data into DataGridView

That's all. Try!

Posted 23-Dec-14 2:52am

Maciej Los

Comments

[no name] 23-Dec-14 9:51am

+5 good advices.
Bruno

Sorry I need to add this:
"Calculating Exponential Moving Average from comma text file". Is it different from "Calculating Exponential Moving Average from excel file" or any datasource....?

Maciej Los 23-Dec-14 10:57am

Thank you, Bruno.
The type of data source is not important (Excel, comma separated file, binary file, etc.). It's quite simple for implementation.

[no name] 23-Dec-14 11:05am

that was my intention to express ;)

Maciej Los 24-Dec-14 2:38am

Explain what?
Link is broken and moves to this question.

myproject235 24-Dec-14 3:02am

Calculating Exponential Moving Average in excel

myproject235 24-Dec-14 3:16am

delete it there is nothing ...........
thanks

Maciej Los 24-Dec-14 3:19am

Got it. And what do you expect from me?