Opens in a new tab

A bi-weekly challenge from Andre Mirabelli & Opturo

If you use “Purchases in the Basis Dietz”, how do you approach the following scenario?
The cash in a portfolio starts the day with a small gain and then the portfolio uses all of the starting cash and half of that small cash gain (“sells cash”) to purchase a non-cash instrument. Thus, nothing ever goes short.


If, as many suggest, one uses a “purchases at open and sales at close” Dietz calculation for the trade-inclusive return of a component of a portfolio on a single day, in order to keep non-cash returns reasonable in the presence of large sales, how should one calculate the weight and return of cash so that weights still sum to one and the returns of all holdings roll up appropriately to the portfolio return, without having an actual gain in cash being described by an unreasonably large negative cash return? To avoid this problem, would it be OK if the returns of un-traded holdings change just because other items in the portfolio are traded?

A bi-weekly challenge from Andre Mirabelli & Opturo

Related news

Make Investment Reporting and Data Management Effortless

Ever wonder how to make sense of performance and risk — after the fact, with precision and speed? With Opturo's SAYS Platform™, our Ex-Post Return / Risk Analytics feature turns historical data into actionable intelligence. Whether you're analyzing portfolio volatility, drawdowns, or Sharpe ratios across custom timeframes, we automate what traditionally takes hours — down…
Read more

Opturo Launches SAYS Platform™ For Simple Turnkey Investment Analytics & Custom Applications

Sarasota, FL, May 13, 2019 (GLOBE NEWSWIRE) -- Opturo, Inc, an enterprise data management and analysis software provider of performance, attribution and risk analytics, announced the release of its new Software At Your Service‚ (SAYS) Platform; a PATENT PENDING versatile cache driven, cloud hosted platform which provides users with the tools to rapidly deploy Custom…
Read more

Opturo’s Enhanced Union/Vlookup Feature for Seamless Data Unification

🔍 Ever spent hours reconciling disparate datasets, only to end up with more questions than answers? At Opturo, we get it. That's why SAYS Platform™ now includes an enhanced Union / Vlookup feature—built for analysts and data professionals who need agility without sacrificing accuracy. Here's how one of our clients is using it: They manage…
Read more