Total 50,358 skills, Data Processing has 2556 skills
Showing 12 of 2556 skills
Migrates Oracle PL/SQL stored procedures to PostgreSQL PL/pgSQL. Translates Oracle-specific syntax, preserves method signatures and type-anchored parameters, leverages orafce where appropriate, and applies COLLATE "C" for Oracle-compatible text sorting. Use when converting Oracle stored procedures or functions to PostgreSQL equivalents during a database migration.
Build robust backtesting systems for trading strategies with proper handling of look-ahead bias, survivorship bias, and transaction costs. Use when developing trading algorithms, validating strategies, or building backtesting infrastructure.
Create effective data visualizations with Python (matplotlib, seaborn, plotly). Use when building charts, choosing the right chart type for a dataset, creating publication-quality figures, or applying design principles like accessibility and color theory.
Web scraping with anti-bot bypass, content extraction, undocumented APIs and poison pill detection. Use when extracting content from websites, handling paywalls, implementing scraping cascades or processing social media. Covers requests, trafilatura, Playwright with stealth mode, yt-dlp and instaloader patterns.
A-share financial data toolkit. Provides scripts to obtain real-time A-share market quotes, financial indicators, share increases/reductions by directors, supervisors and senior executives, northbound capital flows, and macroeconomic data (LPR, CPI/PPI, PMI, social financing, M2). Used when real-time A-share market data is required to support investment analysis. All data sources are free and no API key is required.
Evaluates market bubble risk through quantitative data-driven analysis using the revised Minsky/Kindleberger framework v2.1. Prioritizes objective metrics (Put/Call, VIX, margin debt, breadth, IPO data) over subjective impressions. Features strict qualitative adjustment criteria with confirmation bias prevention. Supports practical investment decisions with mandatory data collection and mechanical scoring. Use when user asks about bubble risk, valuation concerns, or profit-taking timing.
Retrieve Chinese financial market data (A-shares, Hong Kong stocks, US stocks, funds, futures, bonds). Supports over 220 Tushare Pro interfaces: stock quotes, financial statements, macroeconomic indicators. Use this when users request stock price data, financial analysis, index quotes, macro data such as GDP/CPI, etc.
Execute read-only SQL queries against multiple MySQL databases. Use when: (1) querying MySQL databases, (2) exploring database schemas/tables, (3) running SELECT queries for data analysis, (4) checking database contents. Supports multiple database connections with descriptions for intelligent auto-selection. Blocks all write operations (INSERT, UPDATE, DELETE, DROP, etc.) for safety.
Tushare is a financial data interface package with rich data content, such as market data of stocks, funds, futures, digital currencies, etc., and fundamental data including corporate finance, fund managers, etc. This module unifies the external service mode of data assets through standardized APIs, helping technical users in need to access relevant data in a more real-time, concise and lightweight way.
Fetch hot finance news, unified trends, and prediction financial market data. Use when the user needs real-time financial news, trend reports from multiple finance sources (Weibo, Zhihu, WallstreetCN, etc.), or Polymarket finance market prediction data.
Use akshare to obtain real-time and historical data of China's financial market. Use this skill when you need to query real-time quotes, historical data, and financial statements of financial products such as A-shares, Hong Kong stocks, US stocks, indices, funds, futures, etc.
Open, create, read, analyze, edit, or validate Excel/spreadsheet files (.xlsx, .xlsm, .csv, .tsv). Use when the user asks to create, build, modify, analyze, read, validate, or format any Excel spreadsheet, financial model, pivot table, or tabular data file. Covers: creating new xlsx from scratch, reading and analyzing existing files, editing existing xlsx with zero format loss, formula recalculation and validation, and applying professional financial formatting standards. Triggers on 'spreadsheet', 'Excel', '.xlsx', '.csv', 'pivot table', 'financial model', 'formula', or any request to produce tabular data in Excel format.