WEBVTT

1
00:00:00.020 --> 00:00:06.480
Alright, you wanted to see, among these AI tools, this Claude Excel.

2
00:00:07.000 --> 00:00:18.460
So in a way this now makes Excel users either really efficient, or it makes mediocre types really good.

3
00:00:18.960 --> 00:00:22.820
I'll put a portfolio on the line here, so this is this Nordnet equity savings account.

4
00:00:23.200 --> 00:00:28.420
It now has a market value of 87,735 euros.

5
00:00:29.160 --> 00:00:35.680
Originally 50 grand was put into it, and sure there's a good return here, but there have been some illogical moves made.

6
00:00:36.460 --> 00:00:40.440
I mean I've been buying way too many US stocks. They have of course performed very well.

7
00:00:41.020 --> 00:00:44.840
There you see Alphabet and Shopify, so 180 percent.

8
00:00:46.060 --> 00:00:58.220
But I mean, tax-efficiently it wouldn't make sense to invest only in British and Finnish stocks, because those US stocks carry a 12 percent withholding tax that doesn't get refunded in this equity savings account.

9
00:00:58.980 --> 00:01:10.100
I could actually code this too, then, um, into Claude Excel here, as a suggestion to sell those tax-inefficient stocks.

10
00:01:10.430 --> 00:01:19.240
Now let's go over to the Excel side. Let's open this Claude in Excel, and this is installed as an Excel add-on.

11
00:01:20.040 --> 00:01:35.640
And now I'll put in here to copy the attached portfolio so that the euro-denominated amount is correct.

12
00:01:35.690 --> 00:01:47.000
And the companies' tickers can also be found from external sources.

13
00:01:47.900 --> 00:01:59.460
Pay attention to the exchange rates, Euro, GBP, and USD.

14
00:02:01.240 --> 00:02:06.120
Alright, then let's get this moving.

15
00:02:06.280 --> 00:02:11.360
Then we'll just watch as Claude gets to work.

16
00:02:12.380 --> 00:02:16.800
So it now notices those exchange rates and starts digging into them.

17
00:02:18.200 --> 00:02:26.780
Here, by the way, this Unilever has split these off into that Magnum Ice Cream Company,

18
00:02:26.970 --> 00:02:32.280
and it's been such a small investment that I hadn't even noticed,

19
00:02:32.370 --> 00:02:35.520
but that's how these are going now.

20
00:02:36.120 --> 00:02:43.100
And then here it is, it starts calculating these portfolio values,

21
00:02:43.360 --> 00:02:48.400
and since this Nordnet portfolio report doesn't have quite all the information,

22
00:02:49.480 --> 00:02:52.580
for example about the original acquisition cost,

23
00:02:52.580 --> 00:02:59.180
it has to, in a way, calculate those itself from that return change there.

24
00:02:59.800 --> 00:03:04.900
And then when this exchange rate is still being fixed here,

25
00:03:05.320 --> 00:03:08.280
it then has to take that into account too.

26
00:03:09.540 --> 00:03:15.120
From there it's now digging up these figures, and in quite the right direction,

27
00:03:15.140 --> 00:03:19.260
and yeah, and from there it ended up with nearly the same amount,

28
00:03:19.360 --> 00:03:23.560
there, I mean, it could be that there's that exchange rate rounding,

29
00:03:24.380 --> 00:03:29.440
that is, 87,488, wasn't quite the same as that starting value there,

30
00:03:30.620 --> 00:03:35.440
Or then, well, the share prices are only to two decimal places, let's see.

31
00:03:36.920 --> 00:03:43.180
I could go ahead and instruct it there to arrive at exactly the right figure.

32
00:03:44.160 --> 00:03:48.800
Yeah, well, it actually noticed it itself, so — yes, thanks.

33
00:03:51.100 --> 00:03:54.820
I'm used to being polite to this AI, so I said yes, thank you.

34
00:03:54.820 --> 00:03:56.860
And that thanks needed to be added here.

35
00:03:58.080 --> 00:04:05.840
Then the calculations run. There, we arrived at that exact figure. Awesome.

36
00:04:07.500 --> 00:04:16.480
Well, then that's a bit of an ugly table. In a way the logic is that the totals are just in black, well, it is what it is.

37
00:04:16.579 --> 00:04:28.220
Let's ask it to also add this classic — add a relative valuation table below.

38
00:04:28.600 --> 00:04:52.720
Calculate EV/EBITDA, EV/Sales, EV/Capital Employed for each stock using the 2025 consensus forecast.

39
00:04:54.260 --> 00:04:57.820
There we go, it starts doing that too now.

40
00:04:59.180 --> 00:05:08.920
So this Claude and Microsoft alliance also includes the use of these external data sources, which is absolutely amazing.

41
00:05:09.480 --> 00:05:22.060
Here in Translink's databases we now have, for example, something like S&P Capital IQ, so it could pull these ticker values from there too, which would be a fun demo as well.

42
00:05:22.500 --> 00:05:31.100
But here now it's from its own sources, and one of them, among others, is Bloomberg, so it starts calculating these multiples.

43
00:05:31.820 --> 00:05:47.580
This is, in investment and investment-banking terms, relative valuation — if this multiple is high, then it may possibly be an expensive stock, and vice versa.

44
00:05:48.480 --> 00:06:03.240
Of course you pay for quality, so since here we have some of the world's best companies, like Alphabet, Shopify, Microsoft and Apple, they do deserve higher multiples than, say, our Nokia or Mandatum or Sampo,

45
00:06:03.940 --> 00:06:05.520
not to mention Neste.

46
00:06:06.100 --> 00:06:07.360
But this now starts

47
00:06:07.979 --> 00:06:09.440
calculating these multiples

48
00:06:09.560 --> 00:06:10.640
and then also

49
00:06:13.119 --> 00:06:14.080
adds the source

50
00:06:14.200 --> 00:06:14.760
and then

51
00:06:17.660 --> 00:06:19.140
the median and the average

52
00:06:19.200 --> 00:06:21.460
then calculates that for it. Pretty expensive

53
00:06:21.540 --> 00:06:23.680
stuff I've got, so here as the median

54
00:06:23.780 --> 00:06:24.860
4.5 times

55
00:06:25.400 --> 00:06:27.520
sales, and 16.2

56
00:06:27.720 --> 00:06:28.900
times EBITDA.

57
00:06:29.220 --> 00:06:31.379
This is now this kind of thing, I've indeed had

58
00:06:31.400 --> 00:06:35.720
this kind of wild portfolio, since in principle the idea of this equity savings account is that in it

59
00:06:35.920 --> 00:06:43.660
you could take a bit more risk, and because the gain there then isn't taxed before

60
00:06:43.660 --> 00:06:49.180
it's withdrawn, so like that — and it moves on and then asks these kinds of

61
00:06:49.300 --> 00:06:52.940
whether to add, like, reasonable assumptions, that is whether to add price-to-earnings

62
00:06:53.120 --> 00:06:58.679
multiples, so let's put those in, with a yes, thanks, once again — no need to keep thanking it,

63
00:06:58.800 --> 00:07:00.740
but I've been polite about this.

64
00:07:01.280 --> 00:07:05.640
Well but this is Claude in Excel, an absolutely great thing.

65
00:07:07.360 --> 00:07:12.000
This indeed gets installed as an add-on here in Excel.

66
00:07:12.380 --> 00:07:18.260
And then you need to have this — a Claude license, Pro is enough,

67
00:07:18.260 --> 00:07:19.960
but I of course have Max,

68
00:07:20.160 --> 00:07:23.620
so there are enough tokens to then do

69
00:07:23.620 --> 00:07:26.000
both coding and this kind of Excel work.

70
00:07:26.800 --> 00:07:32.960
Alright, send feedback and also subscribe to the Neuvottelija channel.

71
00:07:34.180 --> 00:07:35.200
Thanks.