MaxDraw down in access

[mike02]

Has anyone calculted max drawdown in access before? I can do it in excel fine, but am not able to figure it out in access,



This is what I discovered last year when i looked into it, but im not sure on how to set it up this way:

http://www.dbforums.com/microsoft-ac...lp-wquery.html

[June7]

I can't get the Excel example to work.

What is max drawdown?

I googled: VBA max drawdown

Review:

http://investexcel.net/2450/maximum-drawdown-vba/

http://answers.google.com/answers/th...id/743329.html

[mike02]

The maximum drawdown is the largest percentage drop in asset price over a specified time period. (peak to trough)

how do I get it to be on a domain on the companyID? see below:

Ideally I would want it to run on my table, ina query. based on the CompanyID, here is my table out put

ID.....CompanyID....MonthlyDate...Return

Inthe Query id like it to list all companys and there max drawdown:

CompanyID....MaxDrawdown

[June7]

That is doing calculation of sequential records and probably requires subquery, not an easy task. Review http://allenbrowne.com/subquery-01.html#AnotherRecord. That query gets a meter reading and the previous meter reading on the same row. That query can be used in another query or as the data source for a report. In either case, do a calculation that substracts the two values and also applies GROUP BY criteria to return the Max value of the calculation for each company.