我们兴奋地分享,5月18日发布expands Anaplan’s reach into new Investment Management use cases. We expanded your toolbox by introducing 11 new investment management functions native in the platform to meet your business needs. Additionally, Anaplan improved the speed to value by enabling exports to .xlsx format, improving the row and column limits that exist in the .xls format. With new export flexibility, save valuable time by easily transferring your data in the format you need, ensuring you get to the next step in your planning process faster.
Investment management functions
We have added these new functions to help you use Anaplan for investment management:
- COUPDAYBS calculatesthe number of coupon days before the settlement date.
-
COUPDAYS returns
the number of coupon days in the coupon period that contains the settlement date.
-
COUPDAYSNC determines
the number of coupon days from the settlement date until the next coupon date.
- COUPNCD calculatesthe next coupon date after the settlement date.
-
COUPNUM returns
the number of coupons payable between the settlement date of a bond and the bond's maturity.
- COUPPCD identifiesthe previous coupon date before the settlement date.
-
DURATION us
es the Macaulay duration to indicate a bond price's response to changes in yield. The Macaulay Duration is the weighted average number of years an investor must retain the bond until the value of its present cash flows equals the amount paid for the bond.
-
MDURATION u
ses the Macaulay duration to tell you what percentage the value of a bond will change
by
for a 1% change in the yield.
-
PRICE returns
the price per 100
monetary units
of a bond that pays periodic interest.
-
YEARFRAC c
alculates the fraction of a year between two dates
.
YIELD determinesthe yield to maturity of a bond—the interest rate that, when used to discount the bond's future cashflows, produces the given price.
Export data to .xlsx format
You can now export data from your model to the .xlsx format. This means that you can export data to Microsoft Excel without the row and column limits that exist in the .xls format.
Known Issue
The Anaplan tab in Salesforce.com is not compatible with Firefox 66.0.3 and later. Please use Chrome or Internet Explorer until this issue is resolved.
Internet Explorer and Edge browsers have limited support for the Anaplan Tab in Salesforce.com. Attempting to access Launchpad while usingInternet ExplorerorEdge browsersleadsto anotificationpage with this information:
- "This content can't be shown in a frame"
- Thisnotificationincludes a link to open Anaplan in a new tab. It is safe to click this link, which resolvesthe issueby opening a new browser tab with the requested page.
Questions, Comments, Kudos, or Concerns?
Do you have feedback on the May 18, 2019 Anaplan platform release? Share your thoughts in theMay 18, 2019 Release Discussion.