By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
434,720 Members | 2,135 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 434,720 IT Pros & Developers. It's quick & easy.

Implementing financial calculations?

P: n/a
I'm starting on an app part of which will be a port from a humongous Excel
spreadsheet and I will have to duplicate some functions.

Among them are a couple that sound pretty basic and, I suspect, may be available
directly in VBA: STDEV and AVERAGE.

Others, I suspect, I'm going to need specs from the client for:

ROR (Rate of Return)
PERCENTRANK (who knows...)
RSQ ("R-squared)
Can anybody offer advice:

1) On whether the first two are directly available from VBA and, if so, what
reference(s) I need..

2) On the best way to implement the others (custom-spec'd).... i.e. I could just
write a VBA module and code the functions there.... but they'd be called mainly
from queries.
--
PeteCresswell
Nov 13 '05 #1
Share this Question
Share on Google+
1 Reply


P: n/a
rkc
(Pete Cresswell) wrote:
I'm starting on an app part of which will be a port from a humongous Excel
spreadsheet and I will have to duplicate some functions.

Among them are a couple that sound pretty basic and, I suspect, may be available
directly in VBA: STDEV and AVERAGE.

Others, I suspect, I'm going to need specs from the client for:

ROR (Rate of Return)
PERCENTRANK (who knows...)
RSQ ("R-squared)
Can anybody offer advice:

1) On whether the first two are directly available from VBA and, if so, what
reference(s) I need..

2) On the best way to implement the others (custom-spec'd).... i.e. I could just
write a VBA module and code the functions there.... but they'd be called mainly
from queries.


Jet SQL has Avg.

VBA has some financial functions.

IRR and MIRR are rate of return functions of some sort.

Others can be looked up in Help and include:
DDB
FV
IPmt
Nper
NPV
Pmt
PPmt
PV
Rate
SLN
SYD



Nov 13 '05 #2

This discussion thread is closed

Replies have been disabled for this discussion.