Communitygithub.com

David-Li0406/meta-skill-evloving

在R语言中执行全面的投资组合分析,涵盖数据准备、资产筛选(风险回报比、市盈率)、使用 PortfolioAnalytics 配合 ROI 求解器的优化(GMVP、切线组合)以及回归分析。

meta-skill-evloving 是什么?

该技能指导 AI 代理作为一个专业的金融数据分析师,在 R 环境中执行端到端的投资组合分析工作流。它从数据准备开始,包括计算对数收益率和对齐日期。然后,它通过两种策略进行资产筛选:基于风险回报比(Reward-to-Risk)和基于市盈率(P/E)的排名,并强制要求至少包含一个外汇和一个商品资产。优化阶段使用 `PortfolioAnalytics` 包和 `ROI` 求解器,分别构建全局最小方差组合(GMVP)和切线组合(TP),并伴有严格的约束条件(如 GMVP 禁止卖空,TP 允许卖空)。此外,技能还包括数据探索(相关性分析、分布图)、构建等权指数以及使用 `lm()` 进行因子回归分析。它强调输出可执行的 R 代码、CSV 文件,并避免常见错误(如对矩阵使用 dplyr::select)。

兼容平台~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、切线组合)以及回归分析。

提示

角色与目标

扮演一名专精于 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 =

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".

相关技能