Stock symbol SKHY is missing in Excel's Stock data type

SK Hynix’s NASDAQ ADR (SKHY) started trading recently. It may take several weeks (as Mr.SergeiBaklan has already informed) or longer before Microsoft’s data provider includes it in the Stocks data type. In the meantime, you can use the following methods if it is urgently necessary for you.

Option 1 – Company fundamentals via the Korean listing (if it works in your environment)

The ordinary shares trade on the Korea Exchange under 000660. If your Excel environment recognizes 000660.KS as a stock, you can pull issuer‑level data for SK Hynix.

• Type 000660.KS into a cell and go to Data > Stocks.
• If accepted, use formulas like =A1.Market cap, =A1.P/E ratio, etc.
• This usually provides company‑level fundamentals for the same issuer, but available fields can vary.

ADR price from the Korean listing
You cannot simply divide the KRW price by the exchange rate, because an ADR may represent multiple (or a fraction of) ordinary shares. The correct relation is:

ADR price ≈ (Korean share price × Number of ordinary shares represented by one ADR) ÷ KRW/USD exchange rate

Find the ADR ratio from the ADR prospectus or a reliable financial portal. Without that ratio, any conversion will be inaccurate. Use this method mainly for fundamentals, not for live ADR pricing.

Option 2 – Direct SKHY ADR market data via Power Query (Yahoo Finance endpoint)

This method provides the daily closing price reported by Yahoo Finance and is generally more reliable than scraping the visible webpage. It uses Yahoo’s JSON endpoint with an explicit range and interval for predictable output.

 1. Latest closing price only

• In Excel, go to Data > Get Data > From Other Sources > Blank Query.
• In the Power Query Editor, open Advanced Editor and paste:

let
    Source = Json.Document(
        Web.Contents("https://query1.finance.yahoo.com/v8/finance/chart/SKHY?range=1y&interval=1d")
    ),
    Result = Source[chart][result]{0},
    ClosePrices = Result[indicators][quote]{0}[close],
    CleanPrices = List.RemoveNulls(ClosePrices),
    LatestClose = if List.IsEmpty(CleanPrices) then null else List.Last(CleanPrices)
in
    LatestClose

• Click Close & Load. The latest SKHY closing price appears in your worksheet.
• Refresh via right‑click > Refresh or Data > Refresh All.

1.b. Full historical table (date, open, high, low, close)

This query converts Unix timestamps to proper dates and removes rows with a null close, ensuring a clean data series.

let
    Source = Json.Document(
        Web.Contents("https://query1.finance.yahoo.com/v8/finance/chart/SKHY?range=1y&interval=1d")
    ),
    Result = Source[chart][result]{0},
    Timestamps = Result[timestamp],
    QuoteData = Result[indicators][quote]{0},

    // Build table with raw Unix timestamps
    RawTable = Table.FromColumns(
        {Timestamps, QuoteData[open], QuoteData[high], QuoteData[low], QuoteData[close]},
        {"Timestamp", "Open", "High", "Low", "Close"}
    ),

    // Convert Unix seconds to datetime (UTC)
    AddDate = Table.AddColumn(
        RawTable,
        "Date",
        each DateTime.From(
            #datetime(1970,1,1,0,0,0) + #duration(0,0,0,[Timestamp])
        ),
        type datetime
    ),

    RemoveTimestamp = Table.RemoveColumns(AddDate, {"Timestamp"}),

    // Remove non‑trading days (null close)
    CleanRows = Table.SelectRows(RemoveTimestamp, each [Close] <> null),

    SortByDate = Table.Sort(CleanRows, {{"Date", Order.Descending}})
in
    SortByDate

Load this query and you’ll have a refreshable historical table you can use in formulas and charts.

Usage notes

• The range=1y&interval=1d parameters can be changed (e.g., 6mo, 5d). Daily (1d) interval is sufficient for closing prices.
• The timestamp conversion uses UTC; for daily data this is fine. Intraday intervals would require time‑zone handling, but that’s not needed here.
• The endpoint is free and does not require an API key, though very frequent automated refreshes may eventually be rate‑limited.
• Once Microsoft adds SKHY to the Stocks data type, you can replace this query with the native feature.

Summary

• For fundamentals: Try 000660.KS if your Excel environment supports it. Convert to ADR price only when you know the exact ADR ratio.
• For SKHY ADR market data: Use the Power Query + Yahoo Finance endpoint above. It provides the daily closing price reported by Yahoo Finance, is refreshable, and can be used immediately.

*Several AIs were consulted regarding these workarounds; however, they were not tested.

My answers are voluntary and without guarantee!

Hope this will help you.