skills.rest
guyman-tr
guyman-trCOMMUNITY
Explore all skills by this author →
GitHub

Instrument Detection & Lookup

Identify and filter financial instruments by symbol and instrument type.

Updated Aug 27, 2026
Search Tags:#filtering#financial analysis#asset class#instrument identification#instrument metadata
One-click install
npx skills add https://github.com/guyman-tr/Databricks_Knowledge --skill instrument-detection-lookup
Or copy as Structured Prompt for Agent▼
Please help me install this Agent Skill.
Skill: Instrument Detection & Lookup
Source: https://github.com/guyman-tr/Databricks_Knowledge/tree/main/knowledge/skills/_de_existing/de-wsroot-instruments
Command: npx skills add https://github.com/guyman-tr/Databricks_Knowledge --skill instrument-detection-lookup

SYSTEM DOCUMENTATION & REQUIREMENTS

💡 This Skill includes scripts (resource) and references (resource) components.

What problem does it solve?

This Skill unit addresses the challenges of instrument identification and filtering, ensuring accurate data analysis in financial and e-commerce contexts.

Core Features & Use Cases

  • Instrument Identification: Accurately identify instruments based on their unique identifiers and metadata.
  • Filtering: Efficiently filter data based on instrument type, name, or other criteria.
  • Use Case: Utilize this Skill unit to filter a fact table by specific instrument, join with instrument details, or identify instruments mentioned by name or ticker.

Quick Start

Use the instruments skill to filter data for the instrument with Symbol 'TSLA' and InstrumentTypeID '5'.

Frequently Asked Questions about Instrument Detection & Lookup

High-intent search queries and answers about installing and using this skill.

FAQPage Schema
How do I filter financial instruments by ticker symbol and instrument type?▼

You can identify financial instruments using their ticker symbol and instrument type ID. For example, querying for Symbol 'TSLA' and InstrumentTypeID '5' filters the dataset to match those specific metadata criteria accurately.

What is the best way to identify a financial instrument when one asset has multiple IDs?▼

Identifying instruments when one asset has multiple IDs requires resolving suffix patterns and cross-referencing metadata. This process maps the various identifiers to a single underlying asset class, ensuring accurate instrument lookup and preventing duplicate entries.

Can I filter fact tables by specific financial instruments like stocks, cryptos, and ETFs?▼

Yes, you can filter fact tables by specific instruments such as stocks, cryptos, ETFs, and indices. The filtering mechanism uses per-asset-class query patterns to isolate the relevant records and join them with detailed instrument metadata for analysis.

Does instrument identification work across different asset classes with varying suffix patterns?▼

Instrument identification works across different asset classes by applying per-asset-class query patterns and handling suffix patterns. This approach accurately resolves enriched view flags and metadata variations specific to each asset type for precise filtering.

What data do I need to perform accurate instrument identification and lookup?▼

Accurate instrument identification requires access to specific tables and metadata containing unique identifiers, instrument types, and asset class details. This underlying data structure is necessary to resolve complex scenarios like one-asset-many-IDs and suffix patterns.

Related Skills

Explore More Data & Analytics Skills→
fall-development-robfall-development-rob
7

data-figi

Resolve ISIN, CUSIP, SEDOL, and tickers to FIGI and normalized instrument metadata.

Community
Intermediate
CardoAICardoAI

abf-report-runner

Generate comprehensive ABF transaction reports using asset-class methodology from the ABF MCP server.

Official
Advanced
babdulhakim2babdulhakim2

Cryptocurrency Tracing

Analyze blockchain transactions to trace wallet fund flows across cryptocurrencies.

Community
Advanced
CardoAICardoAI

abf-asset-class-context

Resolve asset class strings to ABF MCP server knowledge entries.

Official
Advanced