// The overlap of US ETFs: https://tickerinside.com/spreadsheets/
// Data: TickerInside, CC BY 4.0. Questions: contact@tickerinside.com
let
    Funds = {"VOO", "QQQ"},
    Response = Web.Contents("https://tickerinside.com", [
        RelativePath = "api/v1/overlap.csv",
        Query = [funds = Text.Combine(Funds, ",")],
        ManualStatusHandling = {400, 404}]),
    Checked = if Value.Metadata(Response)[Response.Status] = 200
        then Response
        else error Error.Record("TickerInside",
            Json.Document(Response)[message]),
    Rows = Csv.Document(Checked, [Delimiter = ",",
        Encoding = 65001, QuoteStyle = QuoteStyle.Csv]),
    Promoted = Table.PromoteHeaders(Rows, [PromoteAllScalars = true]),
    Typed = Table.TransformColumnTypes(Promoted, {
        {"by_weight", type number}, {"share_of_a", type number},
        {"share_of_b", type number}, {"in_both", Int64.Type},
        {"correlation_3y", type number},
        {"holdings_as_of_a", type date}, {"holdings_as_of_b", type date}},
        "en-US")
in
    Typed