3Mon·

Hello everyone, as some of you have noticed, there has been an ISIN change for Blackrock.

$BLK
$US09290D1019 (+0.7%)


Depending on the type of your import you have to book this change manually.

(With Open Banking this is done automatically).


You have 2 options for doing this:


Option 1:

You replace the old ISIN US09247X1019 with the new US09290D1019 in every purchase and sale.

The dividends are automatically regenerated.


Variant 2:

You create a sale for the old ISIN US09247X1019 and select your average buy price as the sell price.

This generates a return of +-0%.

You then create a buy on the record date with the old average purchase price and the new ISIN US09290D1019.

The new dividends are then generated automatically.


#support
#isinchange
#getquin

39
51 Comments

profile image
What is actually happening with AI? A number changes. if "new number" then replace ... that already worked 50 years ago. $BLK has been running monthly since 2022 in the savings plan which I enter manually. The purchases now all have to be changed manually?

Nothing else at the bank. Savings plan not executed because the ISIN is different. Hello ?

Is that how it should be? That works better.

@Kundenservice
4
profile image
@finanzperpetuum That is why we have mentioned 2 variants of how to proceed. :)
Banking processes are still very manual, which is why errors are common during the changeover.

In addition, automated solutions are again unfavorable for linked portfolios, as you can sometimes see from the splits. We carry it out on the same day and the broker issues the shares a week later. Correction bookings occur again.
profile image
@Kundenservice if portfolio not connected AND iSIN BLK then replace 😉

Definitely works, was just a small suggestion to improve the customer experience 🤓
3
@Kundenservice Perhaps you should generally rethink and improve the whole process regarding correction bookings instead of always pointing out that there are or will be correction bookings. The correction postings are not a natural phenomenon, but have been developed by you.

What would be the problem with a split to check whether the position size at the broker has already changed in the ratio in which you entered the split in your system and to simply "keep your feet still" instead of reacting with correction entries?

There is so much potential for improvement in the whole area of "correction bookings", just as food for thought :)
profile image
@Cype

If we were to "keep our feet still", we would have to build a data day.
In other words, only call up updates later when splits are booked.

We don't always have the splits in the database immediately, so we would make correcting entries despite the logic of not updating splits.

Or the Open Banking generally updates itself every 72 hours at the most, which should usually be enough for posting splits and ISIN changes, but then there are complaints because we retrieve data so rarely. :)

The correction postings are subject to a simple logic that is also transmitted by finAPI and the like in Open Banking. (In other words, even if we install a delay, the data from finAPI and co. will still arrive).

10 shares with us -> FinAPI transmits 11 shares to the broker -> no transaction with the broker -> FinAPI says "Yes, then just make a purchase as a correction so that it fits".

We already have a logic regarding splits and the adjustment at the broker.
However, not every broker carries out the split on time, which makes such logic almost useless in the end because the data backlog gets longer and longer.

After all, what do we do if the broker does not carry out the split on time, but the user trades again immediately after the price adjustment? :)

Amazon took 4 days with Scalable back then. Tesla at Trade Republic 3 days. At ING, the NVIDIA split was completed on the same day.
@Kundenservice Yes, that's exactly what I meant by "keep your feet still".
It's not that you should stop (of course you shouldn't do anything, as I said, food for thought :)) data from the broker or the interface, but to handle it a little more intelligently.

I don't really think it's relevant whether a user acts immediately after the price adjustment or not, at least not as a whole.
You don't just have one user who syncs his securities account with the broker, but dozens, hundreds or thousands. So perhaps you should look away from the individual "securities account status" towards the "broker status".
(Is the broker already ready / has he booked the split? Yes/No).
You apparently do not receive this data via your interface, but you could derive it yourself from your database. (Example: Ratio 10:1 --> split carried out if the position in the ratio has shrunk by 10:1 for x% of the securities accounts after the reconciliation)

As long as this has not been carried out, "keep your feet still" and possibly give the user a note in the position "Unfortunately your broker has not yet carried out the split, please be patient", instead of producing scrap data and giving the user instructions on how to correct it.

I understand the actual situation and your explanation. But I think we agree that there is room for improvement and that it is not a technical impossibility. :)
profile image
In variant 1, the past dividends are not allocated to the new isin
3
profile image
I have just noticed that the dividend is completely missing from the overview. Past as well as future
profile image
@Paddy_ro well, no dividend history is yet available for the ISIN. Maybe it will just take a while until the data is available
1
profile image
All of them are no longer available for me either....
I have now switched to variant 2.
@Paddy_ro wait a little. Comes back automatically
profile image
@Paddy_ro The dividends are now in the database. :)
It always takes a while for the new data to arrive.
4
profile image
I have it as a savings plan with Comdirect. Does anyone know if the old ISIN is automatically replaced or do I have to do it manually?
profile image
@Wealthy1 In the case of an automatic connection, the entire position with the old ISIN is derecognized (sold) and then the new ISIN is booked in (bought).
1
What is the situation at Lam Research? There is a stock split + ISIN change...
1
profile image
@jaheu Do you have the ISIN?
So old and new?
Just enter "Lam Research Split" in Google and it will appear immediately (e.g. financial news). The copy function somehow doesn't work on my iPhone here in the chat...
profile image
@jaheu The split is also included in the new ISIN.

So either enter the new ISIN in the purchases and sales, in which case the split is simply posted to the new ISIN, or enter a sale of the old ISIN and a purchase of the new ISIN.
1
@Kundenservice all right, thanks
@Kundenservice I can update the ISIN of the purchases but not of the sales... then I guess the only option is the other one
profile image
@jaheu You can simply select the other ISIN in the dropdown.
@Kundenservice Option 2 is one possibility. Sale and purchase at the average purchase price. But where can I still find my old average purchase price?
1
profile image
@XXversuchmachtklugXX Securities page -> Portfolio tab -> Average purchase price
profile image
@Kundenservice With variant 1, it is a bit tedious to change the ISIN manually for all transactions. Especially for ongoing savings plans.

In the portfolio, I can simply filter the transactions by share.

It would be great if I could select all transactions for Blackrock by batch processing and change the ISIN for them.

That way it would be done in one step.
I have created a new feature request for this:
https://feedback.getquin.com/b/feature-requests/bulk-edit-for-transaction-isin-change
1
profile image
That comes just in time :)
profile image
@WarrenMunger1989 I told you 😜
1
profile image
I think this also applies to $TNK
?
profile image
@Tenbagger2024 If there was also a 1:1 change there, yes.
1
profile image
Also with $AMS
profile image
why does it not show the split of super micro computer correctly and isin is also different. 900% price gain after split?????
profile image
@Ismetnrw_ We are still waiting for the adjusted price from our data supplier and only then can the chart be recalculated.

Have you already made the ISIN change here?
2
profile image
@Kundenservice no how does it work ?instructions?with parget everything runs automatically by itself.VG
profile image
profile image
@Ismetnrw_ The instructions are similar to the Blackrock ISIN change.
Either change in all transactions or sell the old ISIN and buy the new ISIN at the average price.
1
profile image
@Kundenservice Variant 1 carried out.thank you
1
profile image
I have just tried variant 2 and now I am far too much in profit for the day. The portfolio value is correct but the daily performance has increased by what I am in profit overall with Blackrock...
How exactly does the whole process work?
Among other things, I have automatically deposited my securities account with ING.
Now the old ISIN has been sold for X amount and the new ISIN has been bought for Y amount.
Everything is automated, the difference can be handled manually without any problems.
The total return in the portfolio would be clean except for the current difference.

However, the individual return on the price of the new ISIN is more or less 0%
The change of ISIN is currently considered a realized gain on sale.
The dividends are also still on the old ISIN

What else changes automatically here?

So if this has to be adjusted manually, then I'm looking forward to monthly dividend payers like Main or Realty with a partial special distribution in the event of an ISIN change
profile image
@Mbsmoker The derecognition is technically a sale, as there is no such thing as a "derecognition" in open banking.
Here you use the average buy-in as the selling price.

The "booking-in" is again classified as a purchase in Open Banking and is given the value at the time of booking-in as the price.
Here you also simply change the purchase to the average buy-in and then the return is correct again.

Dividends from Blackrock are automatically transferred to the new ISIN as soon as the data is available, including forecasts.
@Kundenservice I wanted to know the last part. Top 👍
profile image
Hello my dears,
With variant 1, the dividend already paid is no longer displayed.
That is why I have chosen variant 2.
Here you sell the share under the old ISIN and select the purchase price at the time as the selling price; if you have bought more, you select the average price.
(So you should have sold with 0% profit).

Now you buy the share again under the new ISIN and select the old selling price as the purchase price.
The share is then booked back in under the new ISIN at the old purchase price.

Have fun with it 😘.
profile image
@Tenbagger2024 Dividends will be transferred automatically as soon as the new data is available. :)
In other words, the historical data also reappears when you change the ISIN in the transactions.
It just takes a while for the data to arrive.
1
profile image
@Kundenservice
Thank you, I was probably too impatient.
profile image
@Kundenservice

Good evening,
Unfortunately, I have to ask another question on this subject.

I use the automatic connection to TradeRepublik and the conversion of the BlackRock share was also carried out in my portfolio here.
Unfortunately, however, I was charged a 100% negative amount for the old share with the automatic conversion, which means that my performance and balance sheet are no longer correct.

How can I now correct my balance sheet or remove this incorrect negative amount?
Many thanks for your support
profile image
@FloT Simply enter the average purchase price when "selling" the old ISIN. This derecognition then takes place with a return of +-0%.
Deleted User
3Mon
Comment was deleted
View all 7 further answers
Join the conversation