finantic-Portfolio123-not-selectable-in-backtest

Next steps: In Data Manager->Historical Providers:
* Select one of the Portfolio123 entries
* Click "Update Portfolio123 Data"

This should download the dynamic portfolio data from www.portfolio123.com.

After a successful update the "Data Provider-Specific Settings" should show the current state of your dynamic portfolio like this:



And the Portfolio/DataSet should appear in the DataSets tree:

I just checked the Help pages for the Portfolio123 extension.
In the main text the phrase "Please Update the DataSet" is indeed missing. I'll add this in a future build.

However, the FAQ contains the question:
"I created a new DataSet but can't find it in Wealth-Lab"
and the verbose suggestion: "Did you update your DataSet?"

Also there is a subtle hint in the "Data Provider-Specific Settings" pane:
Last Update: Please update the DataSet

Probably a more prominent/obvious hint is required...

Thank you very much for your quick response. I think I understand the process now. I am now getting a message saying that my token is invalid. Can you check that?

Please also note: You need a memebership level "Backtest" or higher to be able to use the API connection between WL and Portfolio123.

Ok. Thank you for your feedback. Best regards Richard

I purchased the “Backtest” subscription. However, it is not working

Looks like another message from portfolio123.com.
Probably the API key changed after you upgraded your subscriotion/ membership level to " Backtest Level".
Please check your API key again.

Thank you very much for your feedback. I can now download the portfolios and they are displayed in the backtester. What I don't understand is why I'm getting this error message. I've tested this with several newly created portfolios and always get this error message.

OK, lets troubleshoot this one:

"Could not load Backtest Data in this Scale/Range"

Background
The Portfolio123 extension provides dynamic Portfolios (from Portfolio123.com) but it provides the symbols only.
The O/H/L/C/V data for these symbols must come from another data provider (due to high license an usage costs at portfolio123.com).

This means you need an historical data provider for all the symbols in a portfolio123 DataSet.

Check Norgate Data
The first thing to check: Does your historical data provider work as expected?
Please go to Data Manager->Historical providers and make sure that "Norgate Data" is checked:

Then go to DataSets->Norgate Data->Nasdaq 100 and double click one of the symbols. This should open a Chart with the data loaded correctly.

Create a Norgate DataSet with all US Stocks
Since a dynamic DataSet from Portfolio123 may contain arbitrary US stocks you should make sure that WL has access to all these symbols through the Norgate Historical Data Provider. The steps to achieve that are described in
Help->Extensions->Portfolio123->Portfolio123 Rankings & DataSets->Create a broad DataSet with historical prices.

Check Data of a Portfoilio123 DataSet
With all previous steps executed successfully you can check if the dynamic DataSet contains correct data.
Go to Data Manager->DataSets->Portfolio123 and click one of these DataSets.
The data window sould display complete data:


Check Benchmark Symbol
Please make sure WL has access to the benchmark symbol ("SPY" in your case).
Open a Chart window and enter "SPY" in the symbol selection box. Make sure it is displayed correctly.

Okay, we're getting closer to the issue. But I still don't understand. From my point of view, Norgate Data is clicked correctly. When I create a data set, I probably have to select dynamic data, which I didn't do. But how am I supposed to do that? Should I enter everything manually when each value is to be tested? I don't know how to proceed here.

I'm a bit lost here. It would be good if there were a few explanatory videos. I've read the instructions several times and still can't figure it out by trial and error.

It appears the symbols have suffixes like :USA. For example A:USA. These symbols won't be recognized by Norgate. DrKoch is there a way to get the symbols without the suffix? Otherwise, you'll need to apply some symbol mapping in the Norgate historical provider.

Obviously Portfolio123 appends a ":USA" postfix to all symbols in your case.
I created a very similar DataSet and it looks llike this:


I don't know why Portfolio123 creates symbols with the :USA postfix in your case. Probably it is related to your Potrtfolio123-Account settings. I used this in my P123 Profile:


And yes, Glitch is right. we need a symbol translation mechanism for the portfolio123 extension.
There is one, but it works on a symbol-by-symbol basis.
It is required to enhance that machanism to use regular expresions and make it handle situations like this.

I'll add this to build 2 of the Portfolio123 extension. But due to holiday season build 2 will take another 2-3 weeks...

If you're using Norgate, you can add a Norgate symbol mapping to remove the suffix. Select Norgate in Data Manager, Historical Providers, and click Symbol Mappings. The following mapping should work:

[\:.*=]

Hello everyone, I changed my account settings to USD and USA. I previously had EUR and Germany in my account settings. Now it works. Thank you very much for your support!

QUOTE:
to remove the suffix.... The following mapping should work: [\:.*=]

That regexp will remove all suffixes. But to remove only the ":USA" suffixes use

[\:USA=]

However, I like the solution in Post #15 the best which avoids regexp mapping altogether.