Help get this topic noticed by sharing it on Twitter, Facebook, or email.

Support for Xetra is missing

Currently Sharesight does not support Xetra (Germany's biggest stock exchange and the 10th biggest of the world) but instead supports FRA (a tiny stock exchange in Germany).
The reason for this is a the following little misunderstanding (as can be seen in this topic: https://getsatisfaction.com/sharesigh...):

Sharesight tried to add the Frankfurt Stock exchange (FWB, Frankfurter Wertpapierboerse), but added FRA (Boerse Frankfurt) instead, thinking it is the same. In fact though FWB consists of two trading venues, one being FRA and one being Xetra. FRA is very small these days and Xetra is the main market in Germany (>90% of all trades in Germany are made here). See here: https://en.wikipedia.org/wiki/Frankfu...

During the day share prices of FRA and Xetra are similar (since Xetra more or less leads the prices). However, FRA closes later than Xetra, and since it is very small by itsfelf, there are large spreads and sometimes weird prices which don't reflect the market value of the stocks. Hence FRA closes often significantly different than Xetra and this is what sharesight records.
This leads to rather strange stock values in my portfolio.

I posted this explanation in the older topic, where the source of the problem couldn't be found (sharesight thought it is because of little errors due to the frequency of updates of the stock price, which is not the actual reason as explained). However, the topic was a little old to be seen and the support also doesn't answer to this question, so I opened a new topic.

I understand that this is a very easy mistake to make, since it is quite complicated.
I would be happy if it can be corrected :)
2 people have
this problem
+1
Reply
  • Hi Jan,

    The FRA Market in Sharesight covers all stocks traded on the Frankfurt Exchange (we have listings for over 16,000 stocks). This includes all stocks traded at the Xetra and Börse Frankfurt trading venues (according to our data provider).

    We separately query end of day prices for these stocks using the valoren number as the primary identifier.

    Are able to provide an example of a stock where the end of day price in Sharesight is not in line with other sources on a particular date? If so, we can certainly query this with our data provider and see if a more appropriate source is available.
  • (some HTML allowed)
    How does this make you feel?
    Add Image
    I'm

    e.g. indifferent, undecided, unconcerned sad, anxious, confused, frustrated happy, confident, thankful, excited kidding, amused, unsure, silly

  • Hi Scott,

    The first three examples I looked at now:
    -Comstage Nasdaq-100 (C011.FRA): 68.76 on FRA/Sharesight and 68.94 on Xetra (difference of 0.26%).
    -Comstage TecDax (E908.FRA): 24.11 on FRA/Sharesight and 24.19 on Xetra (difference of 0.33%)
    -Bayer(BAYN.FRA): 80.38 on Xetra and 80.10 on FRA/Sharesight (difference of 0.35%)

    By looking at more examples, you will see that significant differences are the norm, not the exception. This is not simply from variations in the market. There were some examples in the topic I linked above by someone else. When I first noticed it C011.FRA was off by a lot more, which is why I looked into it in the first place.

    It is nice that you support all listings on the Frankfurt Stock exchange (FWB), but it would be even nicer if you could use the stock prices from Xetra instead of FRA (again FWB = Xetra + FRA) since it is 100 times bigger than FRA and simply the reference market in Germany.
    • Hi Jan,

      Thanks for this information. I have confirmed that our prices do come from FRA and not Xetra as you suggested. We will investigate the possibility of sourcing our end of day prices via Xetra instead of FRA. I don't think the price differences noted above are significant in the sense that Sharesight only has daily prices for this market and our prices do represent a price that the shares were actually traded at. From what I can see the FRA prices are virtually always within the daily range of what the shares traded at on Xerta. Nonetheless I take your point that Xetra is the more liquid market and therefore the most appropriate source for reference prices.

      As a side note, our Master List data indicates that the Xetra market essentially represents a subset of the listings traded on FRA, with the most notable difference being ~3200 funds that appear to exist exclusively on FRA.
  • (some HTML allowed)
    How does this make you feel?
    Add Image
    I'm

    e.g. indifferent, undecided, unconcerned sad, anxious, confused, frustrated happy, confident, thankful, excited kidding, amused, unsure, silly