473,394 Members | 1,866 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,394 software developers and data experts.

Implementing financial calculations?

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
1 1746
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 thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

6
by: John Bentley | last post by:
John Bentley writes at this level: If we think about our savings accounts then division never comes in (as far as I can see). We deposit and withdraw exact amounts most of the time. Occasionaly...
5
by: Patrick Burke | last post by:
If you are a top C++ developer and interested in getting into a top NYC financial firm, please email your resume to pb@navistaff.com. Please give me a call or send an email, I will give you...
70
by: Rajan | last post by:
Hi, I am trying to simulate a memcpy like this void* mem_cpy(void* dest, void* src, int bytes) { dest = malloc(bytes); } Now if I want to copy the bytes from src to dest, how do I copy these...
9
by: sr | last post by:
There is a System.Math class that is very helpful I couldn't imagine any next generation framework or language without one a Math class! What is the issue with having a System.Financial class for...
4
by: Leszek | last post by:
Hello, I need to do some financial calculations on my ASP.NET forms. Under Visual Basic it was pretty straightforward - I just used built-in functions such as PV() (principal value) or PMT()....
4
by: Alphonse Giambrone | last post by:
Not sure where to post this so if anyone has any other suggestion, please post it. A client has asked me to look into the feasability of creating a web based financial application where clients...
2
by: IntraRELY | last post by:
I know this isnt really a VB question per say, but is what I am developing in VB.NET and Excel is the only place that has provided direction. I wanted to ask the public if perhaps you could lend me...
3
by: RD | last post by:
Say Company's financial year starts October First and say we are now March 17th. How do you determine which quarter of the Financial year - not the actual year - March 17th is in. Thanks for any...
6
by: Programador | last post by:
I'm getting this error when running this program: Cannot calculate rate using the arguments provided Module Module1 Sub Main() Rate(360, -694.44444444444446, 244274.69178082192) End Sub
0
by: ryjfgjl | last post by:
If we have dozens or hundreds of excel to import into the database, if we use the excel import function provided by database editors such as navicat, it will be extremely tedious and time-consuming...
0
by: ryjfgjl | last post by:
In our work, we often receive Excel tables with data in the same format. If we want to analyze these data, it can be difficult to analyze them because the data is spread across multiple Excel files...
0
by: emmanuelkatto | last post by:
Hi All, I am Emmanuel katto from Uganda. I want to ask what challenges you've faced while migrating a website to cloud. Please let me know. Thanks! Emmanuel
1
by: nemocccc | last post by:
hello, everyone, I want to develop a software for my android phone for daily needs, any suggestions?
1
by: Sonnysonu | last post by:
This is the data of csv file 1 2 3 1 2 3 1 2 3 1 2 3 2 3 2 3 3 the lengths should be different i have to store the data by column-wise with in the specific length. suppose the i have to...
0
by: Hystou | last post by:
There are some requirements for setting up RAID: 1. The motherboard and BIOS support RAID configuration. 2. The motherboard has 2 or more available SATA protocol SSD/HDD slots (including MSATA, M.2...
0
marktang
by: marktang | last post by:
ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However,...
0
by: Hystou | last post by:
Most computers default to English, but sometimes we require a different language, especially when relocating. Forgot to request a specific language before your computer shipped? No problem! You can...
0
jinu1996
by: jinu1996 | last post by:
In today's digital age, having a compelling online presence is paramount for businesses aiming to thrive in a competitive landscape. At the heart of this digital strategy lies an intricately woven...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.