The tag has no wiki summary.

learn more… | top users | synonyms

2
votes
0answers
169 views

Which method is implemented by Excel's YEARFRAC for ACT/ACT?

I know the algorithm used by Excel to calculate the YEARFRAC(startDate, endDate, basis) for basis=1. Excel calls the method "act/act". A Java re-implentation of Excel's algorithm can be found at ...
2
votes
0answers
409 views

How to correctly construct a value- and equally weighted portfolio consisting of property-types?

A problem of which I couldn’t find the answer on the forum is about the construction of equally-weighted and value-weighted portfolio. I want to compute the equally-weighted property-type portfolio ...
1
vote
0answers
56 views

Clarifying the way in counting number of weeks for calculating historical weekly volatility in Bloomberg

I would like to confirm the way to counting number of weeks for calculating historical weekly volatility in Bloomberg. Given an option with issue date from 14/1/2014 to 13/1/2019, is the proper way to ...
-1
votes
0answers
49 views

Calculating Modified Duration on Excel and Matlab - differences?

I'm currently trying to duplicate the excel formula in a matlab code. However, it seems that I have significant differences when it comes to 29th february and 29/30th August. I also have very small ...