We help IT Professionals succeed at work.

XIRR MS ACCESS 2010

864 Views
Last Modified: 2014-05-28
Hi All,
1. does anyone have some sample code to use xirr in ms access vba? (ideally using an array or query for the data)
2. does it require an excel object, or is it 'built-in' to access 2010 (like IRR?)
3. presumably it doesn't require the atpvbaen add-in anymore?

thank you
Comment
Watch Question

Jeffrey CoachmanMIS Liason
CERTIFIED EXPERT
Most Valuable Expert 2012

Commented:
Sure,
One technique is to "pull" the XIRR function into Access from Excel.
http://oreilly.com/pub/h/3310
(I have a sample if you are interested)

See his link for more resources:
https://www.experts-exchange.com/Database/MS_Access/Q_24665271.html

;-)


JeffCoachman
JeffCoachman
MIS Liason
CERTIFIED EXPERT
Most Valuable Expert 2012
Commented:
This one is on us!
(Get your first solution completely free - no credit card required)
UNLOCK SOLUTION

Author

Commented:
Thanks Jeff.
1. your first (orielly) link has no mention of XIRR (or IRR)? - please send sample code if you have any (specifically 'using an array or query for the data')
2. That is unfortunate, but I will work with that.
3. Apparently IRR is built-in (and doesn't require an Excel Ref) while XIRR does and, prior to 2007, also required the atpvbaen add-in.

Author

Commented:
Thanks Jeff
still looking for sample code.
Jeffrey CoachmanMIS Liason
CERTIFIED EXPERT
Most Valuable Expert 2012

Commented:
<1. your first (orielly) link has no mention of XIRR (or IRR)? - please send sample code if you have any (specifically 'using an array or query for the data')>

I am currently away from my home computer with my samples ...

The code listed in the O`reily link referred to FV and Percentile.
You can pretty much take the Percentile code function there and substitute the word "XIRR" for the word "Percentile" in the function.

You will only have to add another Field argument, and a date Variable (and the associated code for them) in the code.
(and IIRC, add a rst.MoveFirst to the second redim to loop the second field...)

Fairly straightforward.

Let me know how you get on...
;-)

JeffCoachman
Unlock the solution to this question.
Join our community and discover your potential

Experts Exchange is the only place where you can interact directly with leading experts in the technology field. Become a member today and access the collective knowledge of thousands of technology experts.

*This site is protected by reCAPTCHA and the Google Privacy Policy and Terms of Service apply.

OR

Please enter a first name

Please enter a last name

8+ characters (letters, numbers, and a symbol)

By clicking, you agree to the Terms of Use and Privacy Policy.