| Table of Contents |
|---|
General
How do I access Canopy?
Canopy is easily accessible from any web browser on desktop, laptop, tablet or smartphone. Be sure to Favorite Canopy in your Bookmarks Bar!
Canopy portfolio visualizer: https://secure.canopy.cloud/
Canopy Engine: https://engine.canopy.cloud/
What information is required for an initial upload?
In order for Canopy to help you visualize the full picture, please provide us with the following bank statements:
- Holdings Statement (or Summary of Assets, or Portfolio Report)
- Cash Account Statements (or Statement of Current Account)
- Transaction Advice
Ensure that the bank statements are in original electronic PDFs and not scanned paper copies. You may easily request your Banker to provide this on a recurring basis.
How do I upload non-financial assets?
Non-financial assets include real estate, cars, wine, art collection etc.
If you would like us to upload this information for you, please provide us with as much information as you can about the Cost Price, Price Date, Valuation (if available) etc.
You may download our template: Transactions & Asset Holdings Template.xlsx for faster processing.
If you are uploading on yoFur own in Engine, navigate to Securities > Manual Security Creation, click on Add Private Equity, select relevant Instrument Type and fill in holding details. Also refer to this article on Creating Private Securities.
How do I search for my Ticker?
Canopy offers a few options to help you easily find your ticker. Refer to this article: Finding and Creating Securities
Data
What is Canopy's price data source?
Our main pricing source is Bloomberg. Prices are updated with end-of-day prices for the previous day. For private instruments such as private funds or structured derivatives issued by your bank, public pricing data is often not available. In such cases, we take the latest price from statements provided by you.
How often is the data updated?
Your data is updated whenever we get fresh information. If all we are getting from you is monthly statements, then your data is updated monthly. In case your bank or broker provides daily data feed in any format – including Secure File Transfer Protocol (SFTP) or SWIFT or secure email – Canopy will be updated daily. You can always update any intra-months movements in Engine.
How do I anonymize my data before uploading it?
You can use Canopy’s inbuilt custom PDF Anonymizer tool to remove Personally Identifiable Information (PII) before uploading your data into Canopy. More information on this topic is available here.
Is there an easy way to manually upload multiple transactions in Engine?
The simplest and quickest way to upload multiple transactions in Engine is by using the Canopy UL spreadsheet. More information on this topic is available here.
Where can I view transactions?
All transactions can be viewed under the transactions blotter. More information on this topic is available here.
Where can I view holdings?
All holdings can be viewed under User Accounts. More information on this topic is available here.
How is NAV calculated?
Detailed information on NAV/performance calculations can be found here.
How can I add a new security which is not importable via Bloomberg?
In cases where new securities cannot be imported via Bloomberg, you can use the Manual Security Creation feature to set-up a private security. More information on this topic is available here.
How can I add new security prices?
The securities feature in Engine allows you to create/delete/add new prices. More information on this topic is available here.
How can I upload my Real Estate Transactions?
Real Estate transactions can be booked like normal Purchase/Sale transactions with Quantity being 1 and price being the current value of the real estate. More information on how to upload transactions can be found here
I have more questions!
...
Where is this database located? Who all have access to it?
This database is located in the Amazon Web Services (AWS) cloud in Singapore. We create a separate database for each customer and only that customer has access to it. This data can only be access from computers that have been specifically authorized to access it.
Can I create my own tables in this database?
This database contains only your data and you have full access rights to it. You can choose to add new tables, run queries or do any other analysis that you would like to do
Can I do something to damage the data?
The database contains a set of tables that are managed by Canopy. These tables are synced once a day to our main database. In case you inadvertently damage or delete any of the tables, Canopy will repair the damage automatically next day. Of course this does not apply to any tables that you created
Technology
Can I connect to this database directly from Microsoft Excel?
Yes. That is not a problem at all. Enclosed is a short Youtube video. Please contact customer support in case of any issues
| Widget Connector | ||
|---|---|---|
|
Can I connect to this database using Python, C# and other programming languages?
Yes of course. Please contact customer support in case of any issues