Skill UI

A professional tool for building Discounted Cash Flow (DCF) valuation models directly in Excel. This skill generates a comprehensive, multi-sheet model including FCF projections, WACC calculations, terminal value analysis, and two-way sensitivity tables. It is designed for investment banking and corporate finance professionals needing to determine intrinsic or enterprise value.

Structured guidance for TAM/SAM/SOM calculations, combining top-down, bottom-up, and value-theory methods for startup market analysis and fundraising planning.

This skill finds and compares decentralized finance (DeFi) yield opportunities across various protocols. It aggregates crucial data, including APY/APR calculations, Total Value Locked (TVL), and comprehensive risk assessments. Use it when researching yield farming strategies, comparing cross-chain protocols, or optimizing crypto investment returns.

Summarizes React’s official guidance on when to use or avoid useEffect by highlighting derived state handling, expensive calculations, subscriptions, and cleanup strategies for data fetching.

This skill provides a comprehensive toolkit for calculating essential portfolio risk metrics. It includes Value at Risk (VaR), Conditional VaR (CVaR), Sharpe Ratio, Sortino Ratio, and drawdown analysis. It is crucial for measuring overall portfolio risk, implementing risk limits, building sophisticated risk dashboards, and ensuring compliance for regulatory reporting in finance.

Automates guidance for statistical significance calculations in data analytics, offering triggered best practices, example implementations in SQL, visualization, and BI workflows, plus validation against common standards.

A comprehensive foundation skill for monitoring cryptocurrency markets. It provides real-time quotes, 24-hour change metrics, and deep historical price data for over 10,000 coins. Users can track specific symbols, view predefined watchlists (e.g., DeFi, Top 10), or export detailed OHLCV data in CSV format. This skill serves as the foundational data layer for crypto portfolio management, tax calculation, and DeFi analysis applications.

Defines strict guidelines for creating and maintaining Excel financial models, covering zero formula errors, industry color coding, number formatting, documented assumptions, and mandatory use of Excel formulas to ensure accuracy and auditability before recalculation.

Guides multi-location retailers through demand forecasting, safety stock calculation, replenishment planning, promotional lift estimation, and ABC/XYZ segmentation, blending statistical best practices with ML-ready feature engineering to balance service levels and inventory costs.

Datamol wraps RDKit with Pythonic APIs tailored for drug discovery, offering SMILES/SELFIES/InChI parsing, standardization, descriptor and fingerprint calculation, clustering, 3D conformer workflows, and parallel/cloud-aware batch I/O while returning native rdkit.Chem.Mol objects.

GeoPandas extends pandas for geospatial vector data, enabling reading/writing shapefiles, GeoJSON, GeoPackage and PostGIS, performing CRS management, spatial joins, overlays, buffering, area/distance calculations, and producing static or interactive choropleth maps.

Helps product managers evaluate whether to build a feature by analyzing revenue connections, cost structure, ROI, and strategic value, then delivers build or don’t-build recommendations backed by financial calculations.