Puyan Capital Control Center

View

Target Return 0.00%

Operating Cost0.00%

CPI Estimate0.00%

Selected Market Outlook0.00%

Step 01

Role User Management

The logged-in operating user can update their own short name and password here. Role authority remains fixed by system policy.

Current role User short name Password

My account changes apply to this workspace.

Live status

Workflow Status Overview

Overall status: waiting for target approval and required data loads.

Target Pending Beta & Drawdown Pending Annual Data Missing Backtest No data Approval Records Not connected Actual Data Missing Report Draft

Equity market value No data Load daily actual holdings to start the 30-day equity value trend.

Formal Workflow Stage

Shows the controlled operating stage from draft through annual review.

Current stage Draft

DraftCurrent

SubmittedPending

ApprovedPending

ImplementedPending

MonitoringPending

Annual ReviewPending

Next control: approve annual target return.

Market pricesMissing

Ticker universeDefault loaded

Proposed portfolioMissing

Actual holdingsMissing

Actual tradesMissing

Cash flowsOptional

Data Load Registry

Tracks source, batch, data date, rows, validation result, and operator for market and actual execution data.

No data load batches yet.

Batch	Data set	Source file	Data date	Rows	Validation	Loaded by	Loaded at
Load market data or actual execution data to create batch records.

Data Load Error Report

Highlights file-level and row-level issues found during CSV loading.

No data load errors.

Batch	Data set	Row	Field	Issue	Suggested fix
No validation issues have been recorded.

Sample demo flow: ready. It uses bundled sample CSV files and simulated committee approvals.

Step 03

Annual Target Return

Estimation period Current date to year end

All return inputs are annualized. The period is a governance record only and does not prorate or annualize the values.

Required operating cost rate

12-Month Market Outlook Conclusion

First choose Bull, Balanced, or Bear. The system then brings out the allowed market outlook band. The Decision Committee enters one final value inside that band.

Bull Market Reference market return range is 5% to 12%.

Balanced Market Market return is between -2% and 2%.

Bear Market Reference market return range is -12% to -3%.

Auto market outlook band Committee-selected market outlook value Must be inside the selected scenario range.

Outlook source date Public source link / note

Fetch public CPI sources or add manual CPI sources before approving the annual target.

Supporting CPI Forecast Sources

The system attempts to fetch public sources. If a source cannot provide a machine-readable value, enter the forecast manually and include it in the average.

Manual source name Manual CPI forecast Source date Source link / note

Manual CPI source is available when public data cannot be read automatically.

CPI estimate is the average of included sources with valid numeric rates.

Result

Live calculation

Final target return 0.00%

Calculated acceptable band0.00% - 0.00%

Operating cost contribution0.00%

CPI contribution0.00%

Market outlook contribution-2.00% - 2.00%

Selected market scenarioBalanced Market

Final target return derived from selected assumptions Operating cost + CPI + selected market outlook value. Initial principal / investment scale

Decision Committee confirms the initial principal before target approval.

Annual profit target ¥0

Target Return Approval

The Decision Committee role approves the final annual target return after the annual public-data package is prepared and before sleeve, beta, and portfolio work proceed.

Target return approval: pending valid target return and committee votes.

Step 02

Annual Public Data Engine

Decision Committee runs or uploads the annual public-data package once per investment year. The approved result feeds target return, sleeve beta, portfolio construction, and later checks.

Role boundary

Owner boundary: Decision Committee accepts annual historical data and scenario allocation assumptions; Execution Team only uses the approved result.

Select a scenario to generate historical allocation guidance.

Market statistics CSV

Manual bond reference return Used only when no generated bond value is available. Manual alternative reference return Used only when no generated alternative value is available. Manual cash reference return Used only when no generated cash value is available.

Run the annual public-data engine at the start of the investment year, or upload standard market statistics CSV manually.

Sleeve	Historical return	Volatility	Max drawdown	Suggested range	Suggested weight

Equity Return/Beta Sleeve	Historical return	Volatility	Correlation note	Suggested share of equity	Portfolio weight

Allocation workflow note

Decision Committee accepts the annual historical statistics and scenario allocation recommendation before target decomposition proceeds.

Step 04

Target Return Allocation by Sleeve

Confirmed allocation decomposes the annual target return across Return/Beta Sleeves before deriving equity-sleeve beta targets. Geographic region remains a separate tag for portfolio constraints and drift monitoring.

Role boundary

Owner boundary: Execution Team prepares sleeve weights and return contributions after target return approval; Decision Committee reviews at the approval gate.

Allocation method

Equity return allocation method is maintained by the system administrator.

Sleeve	Derived target / contribution	Long-term CMA	Risk-free rate	Target beta
U.S. equity	0.00%	VTI 8.00%	4.50%	Invalid
Developed ex-U.S. equity	0.00%		0.50%	Invalid
Emerging markets equity	0.00%		3.24%	Invalid
Bond	0.00%	12M reference	n/a	n/a
Alternative	0.00%	12M reference	n/a	n/a
Cash & cash-like	0.00%	12M reference	n/a	n/a

Equity sleeves use the same CAPM logic; U.S. equity is the active hard-control sleeve.

Total allocated target return 0.00%

Allocated weighted return must match the final target return.

Step 05

Target Beta

Owner boundary: Execution Team prepares CAPM assumptions, beta targets, and drawdown controls; Decision Committee reviews at Step 08.

Risk-free rate Capital market assumption benchmark

CAPM source date Prepared by Source link / note Status

Main result U.S. equity target beta 0.00

Risk limit

Equity Base Max Drawdown

Target return / max drawdown range

Base max drawdown band Invalid

Base equity max drawdown is derived from equity target return and the return/drawdown range. Sleeve budgets are adjusted by historical risk.

CAPM control note

CAPM beta is a hard control for the relevant equity-market sleeve. Whole-portfolio beta is a reference monitor only.

10-Year Benchmark Reference

Calculated from the loaded historical price CSV for the selected benchmark.

10-year mean No data

Years available No data

Year	Return
Load historical price CSV to show benchmark reference returns.

Benchmark Control Map

Clarifies which benchmark each beta control uses and where portfolio beta is applied.

Control item	Benchmark	Control role	System use

Benchmark map updates after CAPM and public market data are available.

Risk Control Targets

Portfolio construction is organized by equity sleeve: U.S., developed ex-U.S., and emerging markets. The security universe remains limited to U.S., Japan, Hong Kong, and China A.

Calculation Rule

Target return range = operating cost rate + CPI estimate + selected 12-month market outlook band.

Step 05 Data

Beta Engine

Upload historical adjusted prices to calculate equity beta against the selected benchmark.

Role boundary

Owner boundary: Execution Team loads historical price data and validates calculated beta inputs.

Historical price CSV Return frequency Lookback window

CSV format Date,VTI,NVDA,AAPL,MSFT No price data loaded yet. Use the standard price CSV template.

Download Template

Step 06

Proposed Portfolio

Proposed equity holdings are organized by sleeve: U.S., developed ex-U.S., and emerging markets.

Role boundary

Owner boundary: Execution Team constructs the proposed portfolio and keeps it inside approved constraints before Step 08 approval.

Equity Construction Controls

Equity Construction Policy

Use the approved sleeve targets, diversification rule, and single-stock limit.

Equity min / max

Bond min / max

Alternative min / max

Cash min / max

Cyclical min / max

Growth min / max

Active min / max

United States min / max

Japan market min / max

Hong Kong market min / max

China A market min / max

Global / cross-region min / max

Max single equity holding % of sleeve

Style diversification 2-5 tickers per style bucket, per sleeve

Constraint details

Checks cover approved sleeve weights, style-bucket ticker counts, and the maximum single-equity holding.

Governance mandate

Decision Committee Mandate

Approves market timing, market selection, style allocation, annual target return, and final implementation.

Execution Team Mandate

Selects specific securities and proposed weights within the approved committee boundaries.

Admin Console

User Administration

The system administrator maintains active users for the decision committee and execution team.

System administrator Current acting user Current acting user permission will appear here.

Role Permission Visibility

Shows which actions the current acting user can perform. Restricted work actions are hidden in read-only views.

Local Data Service Connection

Connect this UI to the local backend for persisted approvals, data loads, and audit records.

Active review role

Local backend status: not connected. Start the local backend, then connect a review role.

Approval Records Console

Run the persisted approval path with named roles, saved records, and audit history.

Target recordNot submitted

Target approval0 / 1

Portfolio recordNot submitted

Portfolio approval0 / 1

Approval records: connect a role, then submit and approve records in sequence.

Business System Configuration

The system administrator maintains trusted public-source priority and core business parameters used by the workflow.

Priority	Source	Institution	Category	URL	Active

Bull low Bull high Balanced low Balanced high Bear low Bear high Drawdown ratio low Drawdown ratio high U.S. risk-free rate % Japan risk-free rate % Hong Kong risk-free rate % China A risk-free rate % Beta tolerance % Return shortfall tolerance % Return excess review % Drawdown excess tolerance % Execution quantity tolerance % Execution value tolerance % Holding completion tolerance pp Single security max % of sleeve Style ticker min Style ticker max Rebalance lower corridor Rebalance upper corridor Rebalance completion days Testing / replay date Equity return allocation method

System defaults are pre-filled. If the administrator does not change a field, the default value will be submitted as the active backend parameter.

Scenario	Equity wt	Bond wt	Alternative wt	Cash wt	U.S. equity share	Developed ex-U.S. share	Emerging markets share

Parameter Maintenance Register

System-admin maintained parameters, grouped by business use, with where each parameter is applied.

Version v1 Not saved yet

Category	Parameter	Current value	Maintenance note	Used in

After reviewing the maintained values, submit them to the backend as the active parameter version.

System configuration: loaded from local defaults until saved by the system administrator.

User	Group	Role	Status

User administration: pending validation.

System Audit Log

Records key changes, approvals, data loads, exports, and execution actions.

Time	Actor	Action	Detail

Approved Ticker Universe

Search the approved ticker universe, then add selected tickers into the proposed portfolio below.

Ticker universe CSV Quick ticker lookup

CSV format Ticker,Name,Market,Region,StyleFactor,Theme Default ticker universe loaded. Use the standard ticker universe template. Ticker lookup uses the imported or public-data-generated universe.

Download Template

Build Proposed Portfolio in System

Select a sleeve, search a ticker above, add it here, then edit weight and lock settings in the proposed holdings table.

Sleeve result U.S. equity construction status Review

Suggestion Basis

Use imported ticker universe, target sleeve weight, single-security limit, and diversification rule.

Ticker source: default ticker universe loaded.

Target sleeve weight 0.00%

Current proposed weight 0.00%

Total tickers 0

Largest sleeve holding No data

Security	Name	Style	Theme	Portfolio weight	Sleeve weight	Beta	Status
No sleeve selected.

Required Changes

Select a sleeve to see construction suggestions.

Sleeve validation details

Sleeve construction checks will appear here.

Step 06 Setup

Execution Team Proposal

The execution team approver proposes the investable securities and weights before system backtest and committee approval.

Execution team approver Proposal status Proposal note

Portfolio version v1

Version status Draft

Lock status Unlocked

Draft version can be edited before approval.

Edit Equity Holdings

Region	Style Factor	Equity Theme	Security	Weight	Beta	Beta Source	Lock	Contribution

Beta Policy

Each equity sleeve uses the relevant market benchmark. Beta is calculated automatically from the selected benchmark unless an authorized manual equity override is recorded.

By Region

By Asset Class

By Equity Theme

Total weight 0.00%

U.S. equity sleeve beta 0.00

U.S. equity target beta 0.00

U.S. equity beta gap 0.00

Portfolio beta monitor - reference 0.00

Portfolio beta note

Portfolio beta is a summary reference versus a blended policy benchmark concept. It does not replace U.S., developed ex-U.S., or emerging markets sleeve beta controls.

Blended Policy Benchmark

Portfolio beta reference is calculated from proposed portfolio returns versus the approved target-allocation benchmark. This is a monitoring metric, not a replacement for equity sleeve beta controls.

Reference beta No data

Observations No data

Benchmark source Policy weights

Sleeve	Proxy	Policy weight	Status
Load Public Data Engine prices to calculate blended benchmark beta.

Uses VTI, 1306.T, 2800.HK, 510300.SS, AGG, GLD, and BIL when those price columns are available.

Step 07

Proposed Portfolio Backtest & Optimization

Test the proposed portfolio against approved return, beta, and drawdown controls at sleeve and summary level.

Owner boundary: Execution Team runs backtests and optimization; Decision Committee receives the final approval package at Step 08.

Backtest lookback period Backtest return frequency

Backtest object System-built proposed equity portfolio only Default backtest setting: 36 months, weekly returns. Historical prices must include the proposed portfolio tickers and their locked benchmarks.

Sleeve Backtest Controls

Sleeve	Locked benchmark	Target return	Backtested return	Target beta	Backtested beta	Drawdown budget	Backtested drawdown	Status
Load historical price data to run the sleeve backtest.

Each sleeve is tested against return, beta, and drawdown controls.

Proposed equity return target No data

Proposed portfolio annualized return No data

Proposed portfolio max drawdown No data

Sleeve beta controls No data

Sleeve return tests No data

Beta tests No data

Sleeve drawdown tests No data

Load historical price data to run the proposed portfolio backtest.

Drawdown alert: load historical price data to monitor drawdown risk usage.

Load historical price data to test the system-built proposed portfolio return and drawdown plus each sleeve's return, beta, and drawdown controls. Each option preserves approved market sleeve weights and changes individual stock weights only.

No option selected.

Optimization Options

Generate options after a backtest requires adjustment.

Minimum Ticker Replacement Plan

The system checks minimum ticker replacements only after weight-only optimization cannot produce a hard-control pass.

Step 08

Decision Committee Approval

The Decision Committee user reviews the proposed portfolio before implementation.

Approval decision: pending system backtest and committee votes.

Implementation status: not ready. Final committee approval is required before investment execution.

Step 09

Load Actual Execution Data - Holdings

Load the standardized holdings workbook exported from the external broker-normalizer tool, then compare actual weights against the approved proposed portfolio.

Broker / Custodian -> Broker Holdings Normalizer -> Standard Holdings Workbook -> This System

Daily standard holdings CSV export Sleeve/style corridor, relative

Accepted rebalance plan Plan execution status Completion deadline, trading days

Plan acceptance No rebalance plan accepted.

Standard holdings import AsOfDate,Account,Broker,Ticker,Name,Currency,Quantity,Price,MarketValue,Weight No standard holdings file loaded yet. Daily broker files must be normalized into this standard format before import.

Download Template

Rebalance alert: no actual holdings loaded yet.

Open drift alerts No holdings load

Completion deadline No holdings load

Escalation status No holdings load

Exception status No exception submitted

Equity Market Value Trend

Daily imported actual holdings are aggregated for equity positions only.

Latest equity value No data

Load actual holdings to start the equity market value curve.

Monthly Corridor Check

Holdings are imported daily for data freshness. Formal sleeve/style corridor checks run monthly; a trade process starts only if the monthly check finds a breach.

Formal check frequency Monitoring owner

Last monthly check No holdings load

Next monthly check After first load

Escalation recipients will; will1976

Monthly corridor check: waiting for first actual holdings load.

Rebalance Follow-up Log

Record whether an alert was handled, deferred, submitted as an exception, or escalated.

Follow-up status Owner Follow-up note

Time	Status	Open alerts	Owner	Note	Actor
No rebalance follow-up has been recorded.

Rebalance Action Plan

When a sleeve/style segment breaches the corridor, the system gives standard trade plans. The execution team chooses a system plan or submits an exception plan.

Plan	Scope	Segment	Ticker	Trigger	Actual Segment	Target Segment	Suggested Action	Trade Amount	Deadline	Status

Scope	Segment	Actual Weight	Approved Weight	Corridor Range	Drift	Status

Rebalance Exception Approval

Submit an exception only when neither standard plan should be executed. The exception still uses the same action-plan format and needs committee approval.

Exception scope / ticker Exception reason

Exception approval: pending ticker, reason, and committee votes.

As Of	Account	Broker	Ticker	Name	Currency	Quantity	Price	Market Value	Actual Weight	Approved Weight	Drift	Status

Step 10

Trade Authorization / Execution Log

Record every buy/sell action. The Execution Team authorizes trades inside delegated authority; over-limit or exception trades escalate to the Decision Committee.

Execution team authorization limit

Trade authorization summary: no trade orders submitted.

Action	Ticker	Quantity	Price	Trade Value	Reason Type	Remark	Execution Authorizer	Authorization Status	Committee Status	Final Status

Actual Trade Reconciliation

Load the standardized trade workbook exported from the broker-normalizer module, then compare actual executions with approved trade orders.

Standard trades CSV export

Standard trades import TradeDate,SettlementDate,Account,Broker,Action,Ticker,Currency,Quantity,Price,Fees,NetValue,ExternalTradeId No standard trades file loaded yet. Load the CSV export after trade execution.

Download Template

Trade reconciliation: no actual trade file loaded yet.

Action	Ticker	Approved Qty	Actual Qty	Approved Value	Actual Value	Qty Diff	Value Diff	Status

Holding completion check: waiting for authorized trades and next holdings load.

Ticker	Authorized Action	Next Holding Due	Target Weight	Latest Actual Weight	Difference	Tolerance	Status

Step 11

Report & Attribution

Investment committee view of valuation, performance, risk, benchmark comparison, data quality, and management attribution.

1 NAV Overview 2 Risk & Contribution 3 Attribution & Export

Formal report status: draft metrics only. Load actual holdings and approve non-equity NAV before issuing.

Report Screen 1 / 3 NAV Overview

Report period Initial principal Custom start Custom end

Non-Equity NAV Review

As-of date Bond NAV Alternative NAV Cash NAV

Non-equity NAV: draft. Submit it before report generation.

Total NAV No data

NAV change No data

Reported return No data

Return target No data

Target status No data

Policy benchmark No data

Active return No data

Maximum drawdown No data

NAV Trend

Latest approved NAV No data

Load actual holdings and approve non-equity NAV to show the report-period NAV curve.

Report Screen 2 / 3 Risk & Contribution

Sleeve Risk Metrics

Annualized return and risk measures by approved equity sleeve.

Sleeve market	Return	Sharpe	Sortino	Volatility

Asset Class Contribution

Current contribution view using available approved valuation data.

Report Screen 3 / 3 Attribution & Export

Management Attribution Bridge

Preliminary governance view. It is not a formally approved Brinson, factor, fee, or currency attribution model.

Attribution basis No data

Attribution conclusion No data

Target-period return No data

Policy benchmark return No data

Excess return vs policy No data

Allocation attribution No data

Selection attribution No data

Beta / execution deviation No data

Review readiness No data

Committee conclusion No data

Execution conclusion No data

Next review action No data

Attribution Item	Contribution	Owner	Result Meaning

Reporting Basis & Disclosures

These statements identify the calculation basis used in the current report and the controls still requiring professional approval.

Return method: No data
Valuation basis: No data
Benchmark basis: No data
Attribution method: Management bridge; professional methodology approval pending.
Data quality statement: No data

This report supports internal governance and review. Market-data estimates do not replace broker, custodian, accounting, fee, tax, or independently validated performance records.

Distribution status Distribution date Recipient group

Report distribution: draft. Export or mark as sent when ready.

System Login

System Administrator

Decision Committee

Execution Team

System Administrator Login

Administrator Access

User Administration

Decision Committee

Execution Team

Select Operating Role

Decision Committee

Execution Team

Decision Committee Login

Execution Team Login

Role User Management

Workflow Status Overview

Formal Workflow Stage

Data Load Registry

Data Load Error Report

Annual Target Return

12-Month Market Outlook Conclusion

Supporting CPI Forecast Sources

Beta Engine

Proposed Portfolio

Equity Construction Policy

Decision Committee Mandate

Execution Team Mandate

User Administration

Role Permission Visibility

Local Data Service Connection

Approval Records Console

Business System Configuration

Parameter Maintenance Register

Approved Ticker Universe

Build Proposed Portfolio in System

Execution Team Proposal

By Region

By Asset Class

By Equity Theme

Proposed Portfolio Backtest & Optimization

Sleeve Backtest Controls

Optimization Options

Minimum Ticker Replacement Plan

Decision Committee Approval

Load Actual Execution Data - Holdings

Equity Market Value Trend

Monthly Corridor Check

Rebalance Follow-up Log

Rebalance Action Plan

Rebalance Exception Approval

Trade Authorization / Execution Log

Actual Trade Reconciliation

Report & Attribution

Non-Equity NAV Review

NAV Trend

Sleeve Risk Metrics

Asset Class Contribution

Management Attribution Bridge

Reporting Basis & Disclosures