A ticker is not an identity

说明与用途

通过验证公司名称、扩展交易所后缀处理并存储每个股票代码的货币，改进了使用 Yahoo 和经纪商标识符的交易系统，避免了因股票代码重新分配导致的错误交易。

问题

Two trading APIs used the same four‑letter ticker to refer to different companies, causing an unintended trade and potential loss.

结果

The system now avoids trading misidentified securities, correctly handles multi‑exchange suffixes, and accurately applies currency for position sizing, eliminating the risk of unintended trades.

工作流

• 1. Retrieve Yahoo ticker and company name from screener.
• 2. Generate candidate broker tickers by appending known suffixes.
• 3. For each candidate, fetch broker company name via instrument lookup.
• 4. Compare fuzzy token sets of Yahoo and broker names; if they match, accept ticker; otherwise refuse.
• 5. Store the ticker’s currency from broker data for downstream calculations.
• 6. Use the validated ticker for order placement.
• 7. Log any refusals for audit.
• 8. Periodically refresh broker instrument list and currency mapping.

证据

A symbol is a display label, not a primary key.

来源

The broker’s London listings all end in the same suffix, l_EQ. Here is what that single suffix actually contains, counted from my own instrument book this morning:

来源