US Exchange Name

Hi,

Currently the fundamental data shows the exchange as “US”, rather than “NASDAQ”, “NYSE” or “AMEX” (or similar). My broker, FP Markets, doesn’t support AMEX but I can’t tell on which exchange a stock is traded, which mostly causes me embarassment but does waste some time.

If it’s already there I’ll feel incredibly silly but happy; if not, could it be added please.

Cheers

Kim

Hi Kim,

We are making some changes to our data formats for the next major update. We’ll make sure this gets in.

All the best

Mathew

Hi,

The “Exchange” field still shows as “US” rather than the actual exchange so I’m guessing there’s a problem with the data provider.

Is it likely to be available in the future or just a supplier problem?

Cheers

Kim

Hi,

The Exchange field references the Short Code of the folder the data is sourced from. Since swapping to the US Equities (Combined) exchange all US Stocks would show US as the result.

Instead, add the MIC field to the Watchlist and you will see the source exchange:

  • XASE - (AMEX)
  • XNAS - (NASDAQ)
  • XNYS - (NYSE)

How do I test against that in a script? I want to scan US equities and only get stock that trades NYSE or NASDAQ.

Thanks again

Hi,

Use the MATCHFUNFIELD() scripting function, released as part of the Optuma 2 update.

https://help.optuma.com/kb/faq.php?id=1242

As an example, here’s the script to find stocks just in the NASDAQ exchange…

MATCHFUNFIELD(FEED=MA, FIELD=MIC, FIELDVALUE=XNAS)

Ex1