I have a strategy I run using daily data over several years. I go to the Equity Curve, right click off the "Show Buy and Hold", then select "Copy Equity Curve Data To Clipboard".
I then paste that data into Excel. The problem is the numbers that are shown after I paste into Excel, do not match (by date) any numbers that are visible in the Equity Curve on the screen, for the corresponding dates. They are not even close. They also don't seem to match buy-and-hold.
Am I missing something ? thx
Size:
Color:
Which product and build?
Size:
Color:
Fidelity WealthLabPro Version 5.3.44.0
Size:
Color:
I haven't been able to reproduce. Maybe you can create a support ticket, specifying the usual inputs + attaching the strategy (or if it happens to a bundled strategy, pointing us to it), the Excel file?
Size:
Color:
My mistake.. was looking at the wrong column. The numbers do in fact match up correctly.
Although... it looks like the "Long" and "Short" columns appear to be reversed after pasting into Excel. Try a "Long" only strategy, then paste the equity curve into Excel. I have numbers in the short column that match the equity curve, but the Long column is constant... But then again, I may be looking at something different :)
Size:
Color:
Good catch, thanks. The order of Long and Short columns is reversed.
Size:
Color:
can the equity curve be displayed in a log scale?
Size:
Color:
Size:
Color:
that's great. thanks. Closed Equity works well for all scripts.
Unfortunately, Strategy Equity and Percent Drawdown in log scale is exactly what i'm looking for, but it doesn't work for SSB (which is required for Symbol Rotation scripts).
Size:
Color:
I understand. To display equity, a visualizer must obtain the data series from one of the Wealth-Lab's interfaces, or build it. Problem is, "equity" per se can and do exist for portfolio simulations only -- hence the limitation.
Size:
Color:
P.S. And I must say,
Net Profit and Percent Drawdown looked so freaky in log scale that this feature had to be disabled. (It's left in the [open source] code -- just commented out.)
Size:
Color:
wycan,
The Long/Short equity curve clipboard bug fix is going to make in in 5.4 shortly.
Size:
Color:
QUOTE:
wycan,
The Long/Short equity curve clipboard bug fix is going to make in in 5.4 shortly.
Sure, that's fine. looking forward to 5.4 !! thx again.
Size:
Color:
2 ss161
Steve, I think that you'll get what you need. In upcoming build of Community.Visualizers, both Net Profit + Drawdown and Strategy Equity + Drawdown are going to work with symbol rotation strategies and switch to log scale back and forth.
Size:
Color:
Steve, this has been implemented.
Size:
Color: