Filter non trading days in numbers spreadsheet for calculating weekly, monthly, yearly returns. Formula should count only trading days as a number of days.I have tried today -7 formula in stockH, but this does not filter non-trading days.
[Re-Titled By Moderator]
MacBook Air 13″, macOS 14.7
If you have a look at the 'My Stocks' template at File > New in your menu you will see a clever way of filtering to produce a chart that does not include non-trading days.
However, you say you are calculating returns here, not producing a chart.
As you probably already know, calculating investment returns can be a complex subject.
Generally it does not involve filtering out non-trading days.
Could you share more details of what you are trying to do? o post a screenshot : shift-command-4, drag to select area, release, start new post here and use the mountains-and-moon 'Image insertion' icon beneath the compose window to attach the screenshot from the Desktop.
SG
I have to calculate no of trading days, for knowning what was price of stock before 7, 30, …… day (in which it counts only trading days, as in formula like today - 7 or today -30 it count all days including non trading days. Network formula also not working properly…
That is not a standard way of calculating investment returns. Also, it is unclear what you mean by "network formula." If you are willing to provide specifics, including a screenshot, we can try to help. Otherwise I wish you good luck with your project, whatever it is.
SG
Filtering non-trading days in a Numbers spreadsheet
