Public User Guide

Explore

Manual Advice/Recommendation Upload

In addition to using the individual rebalance, bulk rebalance, and no change review features in Portfolio Cloud, you can also manually upload recommendations and trades into your projects.

You can upload recommendations into both standard and review projects. For more information on the different types of advice workflows available in each project, please refer to the Advice Workflows section of the user guide.

Manual recommendation uploads are useful when the rebalancing or trade generation is done outside of the Portfolio Cloud system. Common examples include IPOs, new unlisted investments, or corporate actions such as dividend reinvestment.

To manually upload recommendations, you will need to create a CSV file that contains the following information for each client in the set:

IsReview (FALSE for Standard Projects, TRUE for Review/NoChange Projects

IsBrokerage (Always FALSE)

ExternalVariables (Number of ExternalVariables included in row. 0 if none)

Client Number/ID

Provider (Broker or Trade Destination e.g. Open Markets, Salesforce. Must be provided for each trade)

Investment Code/Ticker

Units

ExternalID (SubAccountNumber e.g. Open Markets account number)

ExternalName (SubAccountName - only for use in advice documents. Leave blank if non required)

ExternalVariables: Any client-specific number or text that you need to incorporate into the advice document.

*Indented section optionally repeats for each trade

Once you have created the CSV file, you can upload it into your project in Portfolio Cloud. The system will then process the information and update the recommendations and trades accordingly.

For a discussion on the use of External Variables, refer to

External Variables⁠

The CSV should take the following format

IsReview

IsBrokerage

ExternalVariables

AccountNumber

Provider

Code

Units

ExternalID

ExternalName

ExternalVariable

If ‘Review (No Change)’ Project: IsReview = true

If ‘Standard’ Project: IsReview.= false

If ‘Brokerage’ variable is being used: IsBrokerage: = true

If ‘Brokerage’ variable is not being used: IsBrokerage: = false

Number of external variables used for account: 0-10

Account Number

If multiple trade providers are used they can be specified in this column. If no trade provider, leave BLANK

Instrument Code

Recommended trade units: + for buys, - for sells

SubAccountNumber If no SubAccountNumber, leave blank

SubAccountName If no SubAccountName, leave blank

Any client-specific number or text that you need to incorporate into the advice document.

There are no rows in this table

⁠

For a list of upload examples, refer to

Upload Examples (Standard Project)⁠

and

Trade Upload Examples (Review Project)⁠

Upload the CSV File

To upload the recommendations, create a new Project Create a New Project or enter an existing project.

Click on on the Upload button in the header row

⁠

Screen Shot 2020-05-13 at 3.43.05 pm.png

⁠

This will launch the upload trades dialogue. Click in the Choose File button.

⁠

Screen Shot 2020-05-13 at 3.43.58 pm.png

⁠

This will launch a standard browse file dialogue. Select the file you wish to upload, then click OPEN

⁠

image2018-10-3_18-7-59.png?version=1&modificationDate=1538554081457&cacheVersion=1&api=v2

⁠

You will then return to the Trade Upload dialogue. To finish uploading the CSV, click the Upload Trades button

⁠

Screen Shot 2020-05-13 at 3.48.18 pm.png

⁠

When the upload completes successfully, the results message will be shown in he dialog box. Clock Close to return to the project page.

⁠

Screen Shot 2020-05-13 at 3.47.05 pm.png

⁠

When you return to the project page, the new recommendation should be shown in the advice table. If may take a few minutes for all the trade to be uploaded.

⁠

Screen Shot 2020-05-13 at 3.50.09 pm.png

⁠

Upload Errors

If there are any errors in the CSV file upload will fail, and the errors will be reported in the Trade Upload Dialogue.

⁠

Screen Shot 2020-05-13 at 3.59.27 pm.png

⁠

The error message will indicate which account numbers have issues.

Common reasons for failed up upload include

No account number exists

No brokerage exists but IsBrokerage was set to true

Number in ExternalVariables is different to the number of external variables in the row

Code does not exist

Units is not a number

Want to print your doc?
This is not the way.

Try clicking the ⋯ next to your doc name or using a keyboard shortcut (

CtrlP

) instead.