Compute dividends from E*Trade
Script: Scripts/EtradeDividends.ps1
Usage:
- Log into E*Trade.
- Go to Stock Plan -> Holdings -> Other Holdings.
- Open the web browser inspector (e.g., press
F12
in Google Chrome). - Use the
Network
tab to record the outgoing HTTP requests. - Optionally click the
Clear
button to get rid of the clutter. - Expand the
Cash
section. AgetCashTransactions.json
should appear in theNetwork
view. - Click
getCashTransactions.json
. The view will change, switch to theResponse
tab. - Copy-paste the contents of that tab, save it as
getCashTransactions.json
. - Run the
./EtradeDividends.ps1
in the directory containing thegetCashTransactions.json
. This can take a while since it asks Riksbank's API for the exchange rates at the different dates. - Enjoy a clear list with SEK-converted values, rounded to full kronor.
- Cross-check the USD amounts with the 1042-S form from E*Trade. (
getCashTransactions.json
only looks back 365 days.)
Script: Scripts/EtradeK4.ps1
Usage:
- Log into E*Trade.
- Go to Stock Plan -> Tax Information -> Cost Basis.
- Open the web browser inspector (e.g., press
F12
in Google Chrome). - Use the
Network
tab to record the outgoing HTTP requests. - Optionally click the
Clear
button to get rid of the clutter. - Select the tax year and click
Apply
. AgainsLosses.json
should appear in theNetwork
view. - Click
gainsLosses.json
. The view will change, switch to theResponse
tab. - Copy-paste the contents of that tab, save it as
gainsLosses.json
. - Run the
./EtradeK4.ps1
in the directory containing thegainsLosses.json
. This can take a while since it asks Riksbank's API for the exchange rates at the different dates. - Enjoy a clear table with SEK-converted values, rounded to full kronor, and ready to be copied into the K4 form.