skills.rest
guyman-tr
guyman-trCOMMUNITY
Explore all skills by this author →
GitHub

Portfolio Value (AUM & PnL)

Track end-of-day portfolio AUM, equity, and daily PnL via SQL queries.

Updated Aug 23, 2026
Search Tags:#portfolio analysis#equity monitoring#AUM tracking#PnL analysis#market exposure
One-click install
npx skills add https://github.com/guyman-tr/Databricks_Knowledge --skill portfolio-value-aum-pnl
Or copy as Structured Prompt for Agent▼
Please help me install this Agent Skill.
Skill: Portfolio Value (AUM & PnL)
Source: https://github.com/guyman-tr/Databricks_Knowledge/tree/main/knowledge/skills/_de_existing/de-wsroot-portfolio-value
Command: npx skills add https://github.com/guyman-tr/Databricks_Knowledge --skill portfolio-value-aum-pnl

SYSTEM DOCUMENTATION & REQUIREMENTS

What problem does it solve?

This Skill provides real-time insights into portfolio performance, enabling users to track assets under management (AUM), equity, and profit/loss with precision.

Core Features & Use Cases

  • End-of-Day Snapshots: Access current state of AUM, equity, and market exposure.
  • Daily PnL Tracking: Monitor realized and unrealized profit/loss changes daily.
  • Copy vs Manual Equity Split: Analyze copy-based and manual equity allocations.
  • Use Case: For financial analysts, the skill helps in understanding the impact of market movements on investment portfolios.

Quick Start

Query the Portfolio Value (AUM & PnL) skill for the total AUM on a specific date.

Frequently Asked Questions about Portfolio Value (AUM & PnL)

High-intent search queries and answers about installing and using this skill.

FAQPage Schema
How do I track end-of-day portfolio AUM and daily PnL changes?▼

You can analyze copy-based versus manual equity splits by querying the portfolio analysis skill, which handles both equity allocation types to provide precise insights into profit and loss impacts from different investment strategies.

What is the best way to monitor market exposure and equity for investment portfolios?▼

You can retrieve real-time portfolio performance data by utilizing SQL queries against DDR fact tables, enabling precise tracking of assets under management, equity, and daily profit and loss changes.

How do I analyze copy-based versus manual equity splits for portfolio performance?▼

You can analyze copy-based versus manual equity splits by querying the portfolio analysis skill, which handles both equity allocation types to provide precise insights into profit and loss impacts from different investment strategies.

What is the best way to monitor market exposure and equity for investment portfolios?▼

The best way to monitor market exposure and equity is by accessing end-of-day portfolio snapshots, which provide the current state of assets under management and market exposure for real-time financial analysis.

How do I retrieve real-time portfolio performance data using SQL queries?▼

You retrieve real-time portfolio performance data by utilizing SQL queries against DDR fact tables, enabling precise tracking of assets under management, equity, and daily profit and loss changes.

Does portfolio tracking with SQL require specific fact tables for AUM analysis?▼

Yes, portfolio tracking with SQL requires querying DDR fact tables to accurately retrieve and analyze real-time AUM, equity, market exposure, and daily profit and loss data.

Related Skills

Explore More Finance & Accounting Skills→
Spectra29115Spectra29115

database

Manage PostgreSQL databases and execute read-only SQL queries safely.

Community
Intermediate
Dev-Dennis-040Dev-Dennis-040
10

data-analytics-reporter

Analyze raw data and generate business insights with dashboards and reports.

Community
Advanced
smith6jt-copsmith6jt-cop
3

dashboard-pnl-visualization

Visualize realized and unrealized P&L with cost accounting for Python trading dashboards.

Community
Intermediate
ankity09ankity09

Genie Integration (VDA)

Translate natural language questions into SQL queries for Delta Lake tables.

Community
Intermediate