Disclaimer:
Note that the information here is subject to change right up until the release is live;subscribeand check back frequently for the latest.
We’re excited to share that the upcoming May18th release will expand Anaplan’s reach into new Investment Management use cases. We are expanding your toolbox by introducing 11 new investment management functions native in the platform to meet your business needs. Additionally, Anaplan is improving 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 will add 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 calculates下一个优惠券日期后结算日期。
-
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 will soon be able to 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.
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.
