Demo: Content View - Using JavaScript arrays (2.8+)
-
The attached file adapts some code for Javascript use.
The result is the internal rate of return (IRR).
The data is a set of consecutive annual payments.
This is the same as the IRR function in Excel, so you can test against that for verification.
Further explanation:
http://office.microsoft.com/en-us/excel-help/irr-HP005209146.aspx
http://en.wikipedia.org/wiki/Internal_rate_of_return
Source code prior to adaptation:
http://code.google.com/p/npoi/source/browse/trunk/main/SS/Formula/Functions/Irr.cs?r=227Attachments
IRR Demo.iok 7K -
3 Comments
-
Please note this requires a recent build of Omniscope 2.8.
Alpha partners, see here: http://forums.visokio.com/discussion/1671/omniscope-2.8-alpha-now-available-for-private-testing -
Not yet. We'd have to think about how we managed storage of such a library, the syntax for import, and how to manage dependency recalculation when the library was edited. In short, not entirely trivial. Please post as a separate idea.
However, this idea might be an alternative solution:
http://forums.visokio.com/discussion/comment/3366/#Comment_3366
Welcome!
It looks like you're new here. If you want to get involved, click one of these buttons!
Categories
- All Discussions2,595
- General680
- Blog126
- Support1,177
- Ideas527
- Demos11
- Power tips72
- 3.0 preview2
Tagged
- Content_view58
- scripting31
- JavaScript28
To send files privately to Visokio email support@visokio.com the files together with a brief description of the problem.