Good news about refresh speed. During tests I found that Generated Dividends add significant time to refresh - that is because cash calculation with Generated Dividends is much more complex.
About cost basis (CB) - currently CB calculation is done using average method. How acceptable for you would be if Cost Basis calculation is approximate?
Regarding CB I have no issue with your average method calculation. Regarding acceptance it would be fine as per your old versions. I have no issue in old version with CB Calculations.
Thanks for reporting this! When I pasted formula in web page, all double quotes were replaced by different double quotes (you can see difference if you look very closely even now as quotes in formulas and text above is different) - that is why formula was not accepted. I updated page with right double quotes.
Comments
During tests I found that Generated Dividends add significant time to refresh - that is because cash calculation with Generated Dividends is much more complex.
About cost basis (CB) - currently CB calculation is done using average method. How acceptable for you would be if Cost Basis calculation is approximate?
Regarding CB I have no issue with your average method calculation. Regarding acceptance it would be fine as per your old versions. I have no issue in old version with CB Calculations.
Please try workaround I posted: http://www.portfolioslicer.com/docs/known-limitations.html#cb
Please check and revert.
Thanks for reporting this!
When I pasted formula in web page, all double quotes were replaced by different double quotes (you can see difference if you look very closely even now as quotes in formulas and text above is different) - that is why formula was not accepted. I updated page with right double quotes.