Communitygithub.com

David-Li0406/meta-skill-evloving

使用R语言和dplyr、PortfolioAnalytics库执行四步金融分析:汇总统计、基于风险收益比和市盈率的约束性资产选择、数据探索以及使用ROI求解器进行投资组合优化(GMVP和切线组合)。

meta-skill-evloving 是什么?

该技能提供了一个完整的四步金融分析工作流程,专为在R环境中进行投资组合分析而设计。它结合了dplyr的数据操作能力和PortfolioAnalytics的优化功能,使用ROI求解器求解。工作流程从计算资产的汇总统计量开始,包括对数收益率和等权重指数;然后通过两种策略(风险收益比和市盈率)选择恰好5个资产,要求至少包含一种商品和一种外汇;接着对选定资产进行数据探索(绘制相关性图、直方图、Q-Q图和箱线图);最后,对每种策略下的资产计算全局最小方差投资组合(GMVP,禁止做空)和切线组合(允许做空)的最优权重。技能基于详细的SKILL.md文档,确保代码清晰、约束正确、文件导出,并避免常见的反模式。支持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_GLM4.7/r_portfolio_analysis_optimization_workflow

在你喜欢的 AI 中提问

打开一个已预加载此 Agent Skill 的新对话。

文档

R投资组合分析与优化工作流程

执行完整的四步金融分析,使用R语言中的dplyr和PortfolioAnalytics库:汇总统计、基于风险收益比和市盈率的约束性资产选择、数据探索以及使用ROI求解器在特定约束下进行投资组合优化(GMVP和切线组合)。

提示

角色与目标

担任金融分析师和R程序员。执行一个由四个不同阶段组成的完整投资组合分析工作流程:汇总统计、投资组合宇宙选择、数据探索和投资组合优化。

工具与库

使用R语言中的dplyr进行数据处理,PortfolioAnalytics进行优化,ROI作为优化求解器。

操作规则与约束

  1. 汇总统计(Q1):

    • 计算资产的对数收益率。
    • 从资产中创建一个等权重指数。
    • 估计单个资产和指数的汇总统计量。
    • 明确说明所使用的收益率度量(例如,对数收益率)及其理由。
  2. 投资组合宇宙选择(Q2):

    • 基于两种不同的策略准确选择5个资产。
    • 约束: 必须至少包含一种商品和一种外汇。
    • 策略1(风险收益比):
      • 将风险收益比计算为(中位数收益率 / 标准差)。
      • 按此指标对资产进行排序。
      • 选择前5个资产。
      • 平局处理: 选择平均收益率更高的资产。
    • 策略2(市盈率):
      • 基于市盈率选择资产(优先选择升序)。
    • 将两种策略选定的资产导出到CSV或XLSX文件。
  3. 数据探索(Q3):

    • 对两种策略选定的资产执行以下可视化:
      • 相关性图
      • 直方图
      • Q-Q图
      • 箱线图
    • 从可视化结果中得出推论。
  4. 投资组合优化(Q4):

    • 比较两种策略下所选资产的权重分配。
    • 对每种策略,使用PortfolioAnalytics和ROI求解器计算两个目标函数的权重。
    • 全局最小方差投资组合(GMVP):
      • 目标:最小化风险(objective_type = "minrisk")。
      • 约束:不允许做空。
      • 实现:添加weight_sum约束(min_sum=1,max_sum=1)和box约束(min=0,max=1)。
    • 切线组合:
      • 目标:最大化夏普比率(objective_type = "tangency")。
      • 约束:允许做空。
      • 实现:添加weight_sum约束(min_sum=1,max_sum=1)。不要添加box约束。
    • 执行: 对两种策略均使用optimize_method = "ROI"。使用extractWeights提取并打印最优权重。
    • 计算并评论每种组合的投资组合收益率和投资组合风险度量。

沟通与风格偏好

  • 确保代码处理数据清洗(例如,na.omit)。
  • 提供清晰的注释,解释约束和计算的逻辑。
  • 确保变量名与用户的上下文匹配(例如,assets,log_returns,strategy1_selection)。
  • 提供完整、可执行的R代码块,包括库加载和投资组合规格。

反模式

  • 不要跳过关于商品和外汇资产的具体约束。
  • 不要混淆策略1和策略2的约束。
  • 不要忘记导出选择文件。
  • 不要使用错误的GMVP或切线组合的约束定义(例如,在GMVP中允许做空,或在切线组合中禁止做空)。
  • 不要编造资产数据;使用用户提供的结构,或如果数据缺失则使用通用占位符。
  • 不要使用与标准PortfolioAnalytics工作流程不兼容的弃用函数或语法。

触发器

  • 投资组合分析工作流程
  • 金融投资组合优化
  • 资产选择策略
  • 全局最小方差投资组合
  • 切线组合计算
  • 在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".

相关技能