how to add a clone of typical ETF?

[tomazb]

Hello!

I used Milano version of SDIV (see [https://finance.yahoo.com/quote/SDIV.MI]). What would be the company data for this?

[tomazb]

`

544928174

    <symbol>SDIV</symbol>
    <name></name>
    <taxNumber></taxNumber>
    <address></address>
    <country>IT</country>
</company>`

[tomazb]

and

XLU, XLE as contracts for difference

134770389 XLU

<company>
    <conid>134770358</conid>
    <symbol>XLE</symbol>
    <name></name>
    <taxNumber></taxNumber>
    <address></address>
    <country></country>
</company>

[pronebird]

AFAIK you don't need to update companies.xml with data for CFDs unless you receive dividends which I believe are passed through for CFDs. Typically I'd simply scan my XML output from IBKR to find the contract id (conid) by symbol. But you can also find it online via IBKR: https://pennies.interactivebrokers.com/cstools/contract_info/v3.10/index.php

Company address and tax number are manual labour, usually for the US securities SEC filings contain "employer id", for other securities I'd google it or contact IR.

[tomazb]

I got this message:

companies.xml is missing the following symbols (conids): SDIV (544928174), OXY (10880), XLU (134770389), XLE (134770358) - more info: https://github.com/jamsix/ib-edavki#dodatni-podatki-o-podjetju-za-obrazec-doh-div-opcijsko

And yes, I received dividends from them. And they are listed in the XML for dividends.

So do I need to update companies.xml or not?

[pronebird]

If you received divvy for those then you may want to add those tickers with tax info and addresses to companies.xml and run tax export again. This will prep the tax report for you so that you don't have to type in the same info on edavki website. If you add this info to companies.xml then feel free to send a PR so that others don't have to do that next time :)

[tomazb]

Still, getting info for OXY was easy. But getting them for ETFs and CFDs is tricky. I can do a PR for OXY.

[tomazb]

Info for OXY is here - https://eintaxid.com/company/954035997-occidental-petroleum-corp-%2Fde%2F/

[pronebird]

Yeah it's a known problem, I have some companies in portfolio that have origin in UK but absolutely zero tax info. One way to get this info is to contact the IR directly.

[jamsix]

Regarding CFDs - CFD is a contract between you and IBKR, hence I assume the dividend payer is IBKR, not the company of the underlying asset (stock)?

[tomazb]

The real payer would be the company behind it, as with any stock.

<company>
        <conid>134770389</conid>
        <symbol>XLU</symbol>
        <name>Utilities Select Sector SPDR Fund (XLU@ARCA)</name>
        <taxNumber>20-3783731</taxNumber>
        <address>11 Wall Street, New York, NY 10005</address>
        <country>US</country>
    </company>

[tomazb]

I have the data for XLE and XLU

   <company>
        <conid>134770389</conid>
        <symbol>XLU</symbol>
        <name>Utilities Select Sector SPDR Fund (XLU@ARCA)</name>
        <taxNumber>20-3783731</taxNumber>
        <address>11 Wall Street, New York, NY 10005</address>
        <country>US</country>
    </company>
    <company>
        <conid>134770358</conid>
        <symbol>XLE</symbol>
        <name>Energy Select Sector SPDR Fund (XLE@ARCA)</name>
        <taxNumber>20-3783731</taxNumber>
        <address>11 Wall Street, New York, NY 10005</address>
        <country>US</country>
    </company>

and missing for Global X Superdividend UCITS ETF (SDIV@EBS)

<company>
        <conid>544928174</conid>
        <symbol>SDIV</symbol>
        <name>Global X Superdividend UCITS ETF (SDIV@EBS)</name>
        <taxNumber></taxNumber>
        <address>2nd Floor, Block E, Iveagh Court, Harcourt Road, Dublin 2, Ireland, D02 T330</address>
        <country>IE</country>
    </company>