thanks coaster, I didn't think to take margin requirements into account. But for the most conservative calculations, I will probably still assume that the full margin requirement is at 100%.
But I thought I should be able to take each day's returns and manipulate them to arrive at the same answer as if I was just looking at the first and last day's share price. This works for long positi ...
Hi guys, i'm having trouble calculating the ongoing return in Excel as if I was holding a short position in a stock and i'm really stumped at what i'm doing wrong.
Topic: 