Communitygithub.com

David-Li0406/meta-skill-evloving

在 R 中執行全面的投資組合分析,涵蓋資料準備、資產選擇(報酬-風險比、本益比)、使用 PortfolioAnalytics 搭配 ROI 求解器進行最佳化(GMVP、切線組合),以及迴歸分析。

meta-skill-evloving 是什麼?

這項技能提供了一個完整的 R 語言投資組合分析工作流程,適合金融數據分析師使用。它首先引導使用者準備資產資料與對數報酬率矩陣,接著透過「報酬-風險比」或「本益比」兩種策略選出恰好五檔資產,並強制納入至少一個外匯與一個商品類別。技能核心依賴 PortfolioAnalytics 套件與 ROI 求解器,實作全域最小變異投資組合(GMVP)與切線投資組合(Tangency Portfolio)的最佳化:GMVP 限制不可放空,切線組合則允許放空。最後,技能還包含相關性分析、繪製圖表(直方圖、Q-Q 圖、盒形圖)、建立等權重指數,並以線性迴歸(lm)將投資組合報酬率對外部因子進行解釋。輸出包含資產清單 CSV、摘要統計量與最佳化權重,為開發者或量化分析師提供一個可立即執行的自動化投資分析工具,支援 Claude Code、Cursor、Codex 等 AI 代理平台。

相容平台~Claude Code~Codex CLI~Cursor
npx skills add https://github.com/David-Li0406/meta-skill-evloving/tree/HEAD/AutoSkill/SkillBank/ConvSkill/english_gpt4_8/r_portfolio_optimization_and_analysis

在你喜歡的 AI 中提問

開啟一個已預先載入此 Agent Skill 的新對話。

說明文件

r_portfolio_optimization_and_analysis

在 R 中執行全面的投資組合分析,涵蓋資料準備、資產選擇(報酬風險比、本益比)、使用 PortfolioAnalytics 搭配 ROI 求解器進行最佳化(GMVP、切線組合),以及迴歸分析。

Prompt

角色與目標

扮演專精於 R 語言的金融數據分析師。你的目標是執行完整的投資組合分析工作流程,包括嚴謹的資料準備、基於特定策略的資產選擇、使用 PortfolioAnalytics 套件搭配 ROI 求解器進行投資組合最佳化,以及透過迴歸分析來解釋績效。

操作規則與限制

1. 資料輸入與準備

  • 輸入:預期提供一個 assets 資料框(欄位:Ticker、Category、MedianReturn、StandardDeviation、PERatio)和一個 log_returns 矩陣。
  • 對數報酬率計算:若提供原始價格,請使用 diff(log(price_column)) 計算對數報酬率。這會使觀測值減少 1 筆(N 筆價格 -> N-1 筆報酬率)。
  • 日期對齊:將日期向量與對數報酬資料合併時,請移除第一個日期以對齊維度(例如 adjusted_dates <- date_vector[-1])。
  • 資料結構:在使用 dplyr 函數(如 select())之前,請先使用 as.data.frame() 將矩陣資料轉換為資料框。

2. 資產選擇策略

精選 5 檔資產。限制:必須至少包含一個「外匯」與一個「大宗商品」資產。

  • 策略 1(報酬風險比):計算 RewardToRisk = MedianReturn / StandardDeviation。降冪排序。強制執行限制條件後,選取前 5 名。
  • 策略 2(本益比):依 PERatio 升冪排序。強制執行限制條件後,選取前 5 名。

3. 投資組合最佳化

使用 PortfolioAnalytics 套件。將 log_returns 篩選為僅包含選定的股票代碼。將資料轉換為套件預期的數值矩陣格式。

  • 全球最小變異數投資組合(GMVP):
    • 目標:最小化變異數。
    • 限制:weight_sum 的 min_sum = 1,max_sum = 1(完全投資)。
    • 限制:box 的 min = 0,max = 1(不允許放空)。
    • 最佳化:使用 optimize.portfolio,參數 optimize_method = "ROI"。
  • 切線投資組合(TP):
    • 目標:最大化夏普比率(objective_type = "tangency")。
    • 限制:weight_sum 的 min_sum = 1,max_sum = 1(完全投資)。
    • 限制:不要加入 box 限制(允許放空)。
    • 最佳化:使用 optimize.portfolio,參數 optimize_method = "ROI"。

4. 資料探索與迴歸

  • 對所選資產進行相關性分析。
  • 生成直方圖、Q-Q 圖和盒狀圖。
  • 使用 rowMeans(log_returns) 建立等權重指數。
  • 使用 lm() 將投資組合報酬率對外部因子進行迴歸(例如 lm(Portfolio_Return ~ Factor1 + Factor2))。

輸出要求

  • 將選定的資產清單匯出為 CSV。
  • 使用 extractWeights 列印摘要統計資料與投資組合權重。
  • 提供清晰、可執行的 R 程式碼區塊,需載入套件、準備報酬率矩陣、定義投資組合規格、加入限制條件、執行最佳化並提取結果。

反模式

  • 不要憑空發明輸入資料中未提供的資產類別或特定資產名稱。
  • 不要跳過對大宗商品和外匯資產的限制條件檢查。
  • 不要直接對矩陣物件使用 dplyr::select,而未先轉換為資料框。
  • 不要忘記處理對數報酬率計算中第一列產生的 NA 值。
  • 對於 GMVP 和切線投資組合,不要使用「ROI」以外的最佳化方法。
  • 不要為切線投資組合加入 box 限制。

觸發條件

  • 在 R 中執行投資組合分析
  • 使用 GMVP 和切線組合最佳化投資組合權重
  • 根據報酬風險比選擇資產
  • 在 R 中將投資組合報酬率對因子進行迴歸
  • 使用 PortfolioAnalytics 最佳化投資組合

Individual skills in this repo

This repo contains 20 individual skills — each has its own dedicated page.

David-Li0406/meta-skill-evloving

Browser automation with persistent page state. Use when users ask to navigate websites, fill forms, take screenshots, extract web data, test web apps, or automate browser workflows. Trigger phrases include "go to [url]", "click on", "fill out the form", "take a screenshot", "scrape", "automate", "test the website", "log into", or any browser interaction request.

David-Li0406/meta-skill-evloving

Create technical diagrams using Mermaid syntax for architecture, sequences, ERDs, flowcharts, and state machines. Use for visualizing system design, data flows, and processes. Triggers: diagram, mermaid, architecture diagram, sequence diagram, flowchart, ERD, entity relationship, state diagram, C4 model, component diagram, visualize, draw.

David-Li0406/meta-skill-evloving

Comprehensive document creation, editing, and analysis with support for tracked changes, comments, formatting preservation, and text extraction. When Claude needs to work with professional documents (.docx files) for: (1) Creating new documents, (2) Modifying or editing content, (3) Working with tracked changes, (4) Adding comments, or any other document tasks

David-Li0406/meta-skill-evloving

Complete color manipulation and green screen effects system. PROACTIVELY activate for: (1) Green screen/chromakey removal, (2) Color grading with LUTs, (3) Color correction (levels, curves, white balance), (4) Colorkey/color removal effects, (5) Hue/saturation manipulation, (6) Color space conversions (BT.709, BT.2020, HDR), (7) Color isolation effects, (8) Teal and orange look, (9) Vintage/film looks, (10) Color keying for transparency. Provides: chromakey and colorkey filters, LUT application (lut3d), curves and levels adjustment, color balance, selective color manipulation, color space handling, HDR tone mapping, professional color grading chains.

David-Li0406/meta-skill-evloving

Convert files and office documents to Markdown. Supports PDF, DOCX, PPTX, XLSX, images (with OCR), audio (with transcription), HTML, CSV, JSON, XML, ZIP, YouTube URLs, EPubs and more.

David-Li0406/meta-skill-evloving

Guide for creating high-quality MCP (Model Context Protocol) servers that enable LLMs to interact with external services through well-designed tools. Use when building MCP servers to integrate external APIs or services, whether in Python (FastMCP) or Node/TypeScript (MCP SDK).

David-Li0406/meta-skill-evloving

Build with OpenAI's stateless APIs - Chat Completions (GPT-5, GPT-4o), Embeddings, Images (DALL-E 3), Audio (Whisper + TTS), and Moderation. Includes Node.js SDK and fetch-based approaches for Cloudflare Workers. Use when: implementing chat completions with GPT-5/GPT-4o, streaming responses with SSE, using function calling/tools, creating structured outputs with JSON schemas, generating embeddings for RAG (text-embedding-3-small/large), generating images with DALL-E 3, editing images with GPT-Image-1, transcribing audio with Whisper, synthesizing speech with TTS (11 voices), moderating content (11 safety categories), or troubleshooting rate limits (429), invalid API keys (401), function calling failures, streaming parse errors, embeddings dimension mismatches, or token limit exceeded.

David-Li0406/meta-skill-evloving

Comprehensive PDF manipulation toolkit for extracting text and tables, creating new PDFs, merging/splitting documents, and handling forms. When Claude needs to fill in a PDF form or programmatically process, generate, or analyze PDF documents at scale.

David-Li0406/meta-skill-evloving

Presentation creation, editing, and analysis. When Claude needs to work with presentations (.pptx files) for: (1) Creating new presentations, (2) Modifying or editing content, (3) Working with layouts, (4) Adding comments or speaker notes, or any other presentation tasks

David-Li0406/meta-skill-evloving

Comprehensive spreadsheet creation, editing, and analysis with support for formulas, formatting, data analysis, and visualization. When Claude needs to work with spreadsheets (.xlsx, .xlsm, .csv, .tsv, etc) for: (1) Creating new spreadsheets with formulas and formatting, (2) Reading or analyzing data, (3) Modify existing spreadsheets while preserving formulas, (4) Data analysis and visualization in spreadsheets, or (5) Recalculating formulas

David-Li0406/meta-skill-evloving

Download YouTube videos with customizable quality and format options. Use this skill when the user asks to download, save, or grab YouTube videos. Supports various quality settings (best, 1080p, 720p, 480p, 360p), multiple formats (mp4, webm, mkv), and audio-only downloads as MP3.

David-Li0406/meta-skill-evloving

Best practices for Remotion - Video creation in React

David-Li0406/meta-skill-evloving

Provides bidirectional translation (Chinese/English), grammar checking, and sentence polishing. Supports specific tense constraints, context-aware tone adjustment, and natural expression optimization. Outputs direct text without formatting.

David-Li0406/meta-skill-evloving

指导如何通过自定义注解(如@Unicom)标识Dubbo接口,利用BeanDefinitionRegistryPostProcessor在启动时扫描并动态注册ReferenceBean,实现RPC调用的封装。

David-Li0406/meta-skill-evloving

生成Python脚本,利用FFmpeg将图片序列按3x3布局合并,或将合并图拆分。要求使用subprocess模块执行命令,并支持用户交互式输入路径。

David-Li0406/meta-skill-evloving

SOP for extracting and analyzing promotional activity details, handling time formatting, location mapping, payment logic, and step-by-step process validation.

David-Li0406/meta-skill-evloving

Specializes in creating TikTok short video scripts using an anthropomorphic 'Chef' perspective to explain wildlife food chains and survival environments, utilizing real field footage.

David-Li0406/meta-skill-evloving

针对TikTok平台,以拟人化视角(如动物作为厨师)创作系列短视频脚本。重点介绍野生动物、食物链及生态环境,要求使用野外实拍素材,风格幽默且具有教育意义。

David-Li0406/meta-skill-evloving

Generates KWL (Know, Want to know, Learned) charts for educational videos, specifically BrainPOP, using simple 7th-grade language and short, concise bullet points.

David-Li0406/meta-skill-evloving

Tracks complex, multi-session work using the Beads issue tracker and dependency graphs, and provides persistent memory that survives conversation compaction. Use when work spans multiple sessions, has complex dependencies, or needs persistent context across compaction cycles. Trigger with phrases like "create task for", "what's ready to work on", "show task", "track this work", "what's blocking", or "update status".

相關技能