C# Datagridview and statistics

[Mikey12345]

Hi, Ive been trying to calculate standard deviation from the data in my datagridview.I have manage to work out how to get to the last value but would like to display in a chart so i need to have some kind of running total like you have in Excel. For instance a 20 day Standard deviation would be displayed from the 20 data row and runs all the way to the last value data row. do i need to use some kind of array function.

thanks for you help.

[kvprajapati]

So you want to fetch last 20 records from the database. Isn't it?

[Mikey12345]

At the moment ive set it up as a loop to capture the last 20 data rows to calculate the SDeviation. What i need is to start at the first 20 rows and calculate it all the way through to the last value. Kind of like a running total.

thanks

[kvprajapati]

Take a look at this thread - http://www.daniweb.com/forums/thread39571.html (Range of records)