Back to Category Page
ADVANCED USERS
Excel Add-in
Generate Strategy Transactions

Generate Strategy Transactions

Excel Add-in

Last Updated: ‎‎‎‎‏‏‎ ‎
January 24, 2023

This menu option searches the Single Line Transactions table and retrieves all the transactions that meet the criterion (as defined in Strategy Definitions) for a particular strategy

Strategy Transactions as retrieved from the Excel Add-in
Strategy Transactions as retrieved from the Excel Add-in
Previous
CATEGORY NAME
/

All articles

Generate Strategy Transactions
CATEGORY NAME
/

All articles

Generate Strategy Transactions
Next
INTRODUCTION
/

Welcome to Canopy

Welcome to Canopy
INTRODUCTION
/

We connect to every Bank in the world

We connect to every Bank in the world
INTRODUCTION
/

List of Automated Data Feeds

List of Automated Data Feeds
INTRODUCTION
/

Canopy Use Cases

Canopy Use Cases
DATA ANALYTICS AND VISUALIZATION
/

Canopy Analytics Process

Canopy Analytics Process
DATA ANALYTICS AND VISUALIZATION
/

Segregated Database

Segregated Database
DATA ANALYTICS AND VISUALIZATION
/

Infinitely Configurable Calculations

Infinitely Configurable Calculations
DATA ANALYTICS AND VISUALIZATION
/

High End Customized Reporting

High End Customized Reporting
DATA ANALYTICS AND VISUALIZATION
/

Financial Metrics Dashboards

Financial Metrics Dashboards
EXTRACT TABLES FROM PDFS
/

Extraction of tables from PDF documents

Extraction of tables from PDF documents
EXTRACT TABLES FROM PDFS
/

How does Canopy Extract work?

How does Canopy Extract work?
EXTRACT TABLES FROM PDFS
/

PDF Extract Demo (45 sec)

PDF Extract Demo (45 sec)
EXTRACT TABLES FROM PDFS
/

Canopy UL 2.0

Canopy UL 2.0
EXTRACT TABLES FROM PDFS
/

List of Supported Formats for Canopy Extract

List of Supported Formats for Canopy Extract
META DATA ANALYSIS
/

Evergrande likely a non-issue as investors started exiting in February

Evergrande likely a non-issue as investors started exiting in February
META DATA ANALYSIS
/

Selling across the board as ‘Fall’ season hits the markets

Selling across the board as ‘Fall’ season hits the markets
META DATA ANALYSIS
/

Interest rate ‘Netflix drama’ continues and signs of recovery in HKD equities

Interest rate ‘Netflix drama’ continues and signs of recovery in HKD equities
META DATA ANALYSIS
/

Interest Rate traders finally agree with Bond traders and everyone sells

Interest Rate traders finally agree with Bond traders and everyone sells
META DATA ANALYSIS
/

Tech takes a backseat, China panic subsides as summer break continues

Tech takes a backseat, China panic subsides as summer break continues
DATA UPLOAD & CLEANSING
/

Canopy Data Cleansing Process

Canopy Data Cleansing Process
DATA UPLOAD & CLEANSING
/

Typical Bugs Found in Custodian Statements

Typical Bugs Found in Custodian Statements
STRUCTURED DERIVATIVES
/

What are Structured Derivatives

What are Structured Derivatives
STRUCTURED DERIVATIVES
/

Comprehensive Risk Report in Excel

Comprehensive Risk Report in Excel
STRUCTURED DERIVATIVES
/

Risk Report in Chart format

Risk Report in Chart format
CANOPY INTEGRATIONS
/

Integrations

Integrations
CANOPY ACCOUNT STRUCTURE
/

Introduction to Accounts

Introduction to Accounts
ADVANCED USERS
/

Installing the Excel Add-in

Installing the Excel Add-in
ADVANCED USERS
/

Starting the Excel Add-in

Starting the Excel Add-in
ADVANCED USERS
/

Excel Add-in Menu Options

Excel Add-in Menu Options
ADVANCED USERS
/

Generate Attribution Summary

Generate Attribution Summary
ADVANCED USERS
/

Generate Strategy Transactions

Generate Strategy Transactions
ADVANCED USERS
/

Troubleshooting if Excel Add-in not working

Troubleshooting if Excel Add-in not working
ADVANCED USERS
/

Create Strategies

Create Strategies
ADVANCED USERS
/

Single Line Transactions

Single Line Transactions
ADVANCED USERS
/

Consolidated Holdings

Consolidated Holdings
ADVANCED USERS
/

Strategy Definitions

Strategy Definitions
ADVANCED USERS
/

Strategy Records

Strategy Records
DATA ANALYTICS AND VISUALIZATION
/

Private Equity Dashboards

Private Equity Dashboards
DATA ANALYTICS AND VISUALIZATION
/

Real Estate Dashboards

Real Estate Dashboards
DATA ANALYTICS AND VISUALIZATION
/

Making a New Dashboard

Making a New Dashboard
DATA ANALYTICS AND VISUALIZATION
/

Explainer (Most Used Feature)

Explainer (Most Used Feature)
DATA ANALYTICS AND VISUALIZATION
/

Meta Data Analytics

Meta Data Analytics
DATA ANALYTICS AND VISUALIZATION
/

Fund Look Through

Fund Look Through
DATA ANALYTICS AND VISUALIZATION
/

Demo of the Analytics Process

Demo of the Analytics Process
DATA ANALYTICS AND VISUALIZATION
/

Preparing Your Bank Statements for Upload

Preparing Your Bank Statements for Upload
DATA ANALYTICS AND VISUALIZATION
/

What Information to Anonymize

What Information to Anonymize
DATA ANALYTICS AND VISUALIZATION
/

How to Anonymize Your Statements

How to Anonymize Your Statements
DATA ANALYTICS AND VISUALIZATION
/

Canopy Visualizer Features

Canopy Visualizer Features
META DATA ANALYSIS
/

Investors make a U turn

Investors make a U turn
META DATA ANALYSIS
/

Investors buy Equities and sell Bonds even as interest rates fall

Investors buy Equities and sell Bonds even as interest rates fall
META DATA ANALYSIS
/

Investors ‘wait and watch’ as Fed signals earlier rate hike

Investors ‘wait and watch’ as Fed signals earlier rate hike
META DATA ANALYSIS
/

Signs of activity and a preference for Asian assets as USD loses value

Signs of activity and a preference for Asian assets as USD loses value
META DATA ANALYSIS
/

Investors relax while Bitcoin blows up

Investors relax while Bitcoin blows up
BLOG
/

How Personalised Client Reporting Has Changed Wealth Management

How Personalised Client Reporting Has Changed Wealth Management
BLOG
/

How Right Technology Can Be Transformational For Family Offices

How Right Technology Can Be Transformational For Family Offices
BLOG
/

3 common applications of AI in asset management

3 common applications of AI in asset management