MEGATHREAD: Activity feed CSV export πŸ“©

With the financial year just over I imagine some of us will want to make sure we haven’t exceeded any allowances, or have the right amount of we have. I think exporting to CSV would hopefully be the easiest way to get all the data as it could just be done on device.

With that we could atleast import it into Excell to run our own checks, or even create a specific tool from it!

1 Like

Seconded

and ideally include a breakdown of any dividends pay (the monthly ones don’t currently include this information), both the cash ones distributed to the GIA / ISA, but also the ones that are directly re-invested into the funds themselves. for future benefit , year on year comparison of portfolio/ divided progress.

This topic was automatically closed 416 days after the last reply. New replies are no longer allowed.

Sharing a sneak peek of something coming soon. We will share more next week. :eyes:

24 Likes

We’ve been waiting so long for some initial reporting stuff. This will be a great start!

Can’t wait

4 Likes

iOS only and we riot :fire: :fire:

5 Likes

Will this function be available on Android aswell?

1 Like

Will it be in old format or smth more usable?

1 Like

Hi @Jim_mcgrain @Rcllondon - we are starting with iOS but will follow with Android. We are choosing to not build iOS and Android in parallel so that we can get it out as soon as possible to customers but rest assured Android will follow after.

2 Likes

Hi @Lonli-Lokli it will be an improved CSV format for download. Hoping to share a sample soon with the community to get feedback.

4 Likes

:wink:
riot

4 Likes

Or, it could go into the web site and be platform agnostic? Maybe, a web site only feature so only one set of development time.

Any movement on this feature? Typing this information out into a spreadsheet whilst I hold my phone in my hand to track tax obligations makes me feel like an animal.

1 Like

Hi @thomasknowles - thank you for your patience on this one. We were pulled onto other priorities for a few weeks but the team is back focussing on finishing off this feature. I will post an update again sooner to release on further details about the feature.

4 Likes

I hope finally my converter will be deprecated :slight_smile:

1 Like

Hi everyone

Quick update on the Activity Feed download (CSV) today. We are getting close to launching on iOS (Android to come next) and wanted to get some feedback on the CSV format from the community.

Questions that will help us shape the feature:

  1. Do the CSV header names clear and make sense?
  2. Is there anything else you would expect to see in the download?
  3. Any other feedback is welcome

Please see an excerpt below (note this is just a sample from the team) β†’

Thanks!

Title Type Timestamp Account Currency Total Amount Buy / Sell ISIN Price per Share in Account Currency Stamp Duty Quantity Venue Order ID Order Type Instrument Currency Instrument Amount Instrument Price per Share FX Rate Base FX Rate FX Fee (BPS) FX Fee Amount Dividend Ex Date Dividend Eligible Quantity Dividend Amount Per Share Dividend Gross Distribution Amount Dividend Net Distribution Amount Dividend Withheld Tax Percentage Dividend Withheld Tax Amount
Interest INTEREST 2022-09-15T00:00:00.000Z GBP 0.06
Lloyds DIVIDEND 2022-09-12T12:24:00.000Z GBP 0.24 GB0008706128 30 GBP 2022-08-04 30 0.008 0 0
Interest INTEREST 2022-08-15T00:00:00.000Z GBP 0.07
Avast DIVIDEND 2022-08-12T13:44:00.000Z GBP 0.03 GB00BDD85M81 1 GBP 2022-07-21 1 0.039581 0 0
Apple DIVIDEND 2022-08-11T17:19:00.000Z GBP 0.22 US0378331005 1.397567 USD 0.826 0 0 2022-08-05 1.397567 0.23 0.32 0.27 15 0.05
MSCI World DIVIDEND 2022-07-27T16:50:00.000Z GBP 0.27 7
Interest INTEREST 2022-07-15T00:00:00.000Z GBP 0.04
Lloyds CONTRACT_NOTE 2022-07-14T08:33:47.033Z GBP 4.63 BUY GB0008706128 0.419091 0.02 11 London Stock Exchange SXVQHQG6DZ84 MARKET GBP 4.61 0.419091 1 1
Apple CONTRACT_NOTE 2022-07-07T15:16:23.435Z GBP 4.98 BUY US0378331005 121.062302 0 0.040971 Drivewealth DFT8PZMY38PF MARKET USD 5.96 145.47 1.195227 1.20063 45 0.02
Tesla CONTRACT_NOTE 2022-06-27T14:08:06.851Z GBP 9.97 BUY US88160R1014 607.301191 0 0.016351 Drivewealth 0V3N6I8G4KYS AGGREGATE USD 12.2 746.13 1.222215 1.22774 45 0.04
Lloyds CONTRACT_NOTE 2022-06-27T11:11:35.773Z GBP 4.79 BUY GB0008706128 0.433636 0.02 11 London Stock Exchange FAY4PIGP5O6E MARKET GBP 4.77 0.433636 1 1
S&P Energy Sector CONTRACT_NOTE 2022-06-27T09:24:06.632Z GBP 5.5 BUY IE00B42NKQ00 5.5 0 1 London Stock Exchange 1KCGZUULTA58 MARKET GBP 5.5 5.5 1 1
Top up TOP_UP 2022-06-21T13:08:01.146Z GBP 50
Interest INTEREST 2022-06-17T00:00:00.000Z GBP 0.01
Global Clean Energy DIVIDEND 2022-05-25T18:01:00.000Z GBP 0.12 5
Interest INTEREST 2022-05-17T00:00:00.000Z GBP 0.02
Withdrawal WITHDRAWAL 2022-05-11T15:58:22.813Z GBP 1
MSCI World DIVIDEND 2022-04-29T14:50:00.000Z GBP 0.2 7
Lloyds CONTRACT_NOTE 2022-04-28T14:21:11.025Z GBP 3.71 BUY GB0008706128 0.46125 0.02 8 London Stock Exchange 54ASSYIJLDLF MARKET GBP 3.69 0.46125 1 1
Interest INTEREST 2022-04-19T00:00:00.000Z GBP 0.02
Interest INTEREST 2022-03-15T00:00:00.000Z GBP 0.01
Everyman CONTRACT_NOTE 2022-02-17T10:43:47.566Z GBP 3.82 BUY GB00BFH55S51 1.273333 0 3 London Stock Exchange - Aim MTF W4CX0MHBFMIH MARKET GBP 3.82 1.273333 1 1
Top up TOP_UP 2022-02-17T10:43:26.930Z GBP 10
Interest INTEREST 2022-02-15T00:00:00.000Z GBP 0.02
Cloudflare CONTRACT_NOTE 2022-01-28T15:12:20.994Z GBP 49.92 BUY US18915M1071 58.246849 0 0.853265 Drivewealth S4OJPHV3I3NY MARKET USD 66.64 78.1 1.334975 1.34101 45 0.22
Apple CONTRACT_NOTE 2022-01-28T15:11:49.460Z GBP 49.92 BUY US0378331005 123.295379 0 0.403097 Drivewealth NBJ53Z48CJGA MARKET USD 66.64 165.32 1.335015 1.34105 45 0.22
Netflix CONTRACT_NOTE 2022-01-28T15:11:13.337Z GBP 49.92 BUY US64110L1061 282.085718 0 0.176188 Drivewealth SBOCFLEMCVJH MARKET USD 66.65 378.29 1.335125 1.34116 45 0.22
11 Likes

My first request will be to add ticker in the format NYSE.BABA

2 Likes

Thank you for sharing this @Max_R. It is great.

I would like to see clear markers for Dividend in the form of shares and Dividend in the form of Cash. I would also like to see an entry related to distribution of funds related to Scrip offers (distinct from Dividend). I note that some people who received the WISE offer commented that they received no notification in their feed. I don’t know if this is true or not - but regardless please make sure the Activity feed records the receipt of such bonus shares.

For tax purposes this document is missing information on accumulation funds. When a Fund accumulates you need to indicate it. It is an event significant for tax purposes.

It is good that you are indicating the ISIN. This is perfect and unambiguous.

4 Likes