You can query Yahoo finance to get the Yahoo ticker symbol using elemental (which is basically selenium). Here is the code:
import urllib.parse as urlparse
from urllib.parse import parse_qs
msft = yfinance.Ticker(symbol)
hist = msft.history(period="2d")
SOF.BE is a RIC (Refinitiv code) for the Belgian market. The company's primary listing is XBER (Berlin) as SOF.BR. This is the same stocks trading on a different markets (Berlin vs Belgium) in the same currency so the price should be close enough to be identical.
It is usually much easier to find European stocks if you have the ISIN (BE0003717312 for SOF.BE) ...
Generally analysts will use accounting metrics to compare similarly sized companies operating in the same industry and region, and in the same growth stage. The D/E of a financial company will look totally different than the D/E of a utility company, for example.
Nominal amounts like net profit typically aren't comparable between companies of different size. What's more comparable within an industry are financial ratios like return on assets, net profit margin, etc.
Note that even then, one metric cannot be used alone to determine if one company is a better investment than the other. Many metrics must be considered ...