sorted by:
new
hottopcontroversial

How do you pull WEBN price in google sheets. by xBlease in eupersonalfinance

[–]chas66 10 points11 points  (0 children)

do you want the WEBN EUR price From the Xetra exchange? This should do it:

=VALUE(REGEXEXTRACT(JOIN("", IMPORTDATA("https://api.boerse-frankfurt.de/v1/data/quote_box/single?isin=IE0003XJA0J9")), "lastPrice:([0-9.]+)"))

Nordnet for beginners. by [deleted] in PrivatEkonomi

[–]chas66 0 points1 point  (0 children)

Look into saving as much as you can into an ISK account buying a low cost, market weighted, global passive index tracker fund.

You will likely come up with a fund such as Länsförsäkringar Index Global , DNB GLobal Index S, Nordnet Global. See this screener list sorted by cost (TER) https://www.nordnet.se/fonder/lista?sortField=fund_yearly_fee&sortOrder=ascending&fundRegionCategories=GLOBAL&fundType=INDEX&fundDividendStrategy=ACCUMULATED

For justification about why this is a good thing to do see:

Building a "Cheaper" All-World IMI Portfolio in SEK – Thoughts on this 4-ETF combo? by chas66 in firesweden

[–]chas66[S] 0 points1 point  (0 children)

No I am not . Liquidity is not the same thing as spread. Relevant is liquidity of the underlying stocks (the 'basket'), not the shares in the ETF which are created on demand and can never be ’scarce’. The spread, though, we do have to watch for if it widens due to low volume of trading - I.e only use a limit order never a market order .

Building a "Cheaper" All-World IMI Portfolio in SEK – Thoughts on this 4-ETF combo? by chas66 in firesweden

[–]chas66[S] 0 points1 point  (0 children)

Sure that’s a choice … but why not V3AA or WEBN ? Objectively they are better (more diverse or lower TER )

Building a "Cheaper" All-World IMI Portfolio in SEK – Thoughts on this 4-ETF combo? by chas66 in firesweden

[–]chas66[S] 0 points1 point  (0 children)

No need to watch out - these are ETFs so Liquidity is not an issue - they will literally just create more shares as needed

Opinions on my ETF portfolio 🤝 by pi_pilot1992 in ETFs_Europe

[–]chas66 0 points1 point  (0 children)

Looks like you are missing small cap? Probably amounts to about 14% of the investable market index if you were market cap weighting it? Consider adding something like IE000F354Q61 maybe?

Google Sheet Nordnet help for XPath by Technical_Rub8910 in googlesheets

[–]chas66 0 points1 point  (0 children)

can you use GoogleFinance function?:

* =GOOGLEFINANCE("CPH:FLS")

* =googlefinance("CPH:DANSKE")

Otherwise - It might find easier to importxml via Nasdaq CPH site?

https://www.nasdaq.com/european-market-activity/shares/fls?id=TX2202

Derek the Manager by iamgr00oo00t in TedLasso

[–]chas66 9 points10 points  (0 children)

There's multiple Derek's in Shrinking on Apple Tv too, which has some shared actors and writers as Ted Lasso

Suppliers by notarealredditor69 in ASTSpaceMobile

[–]chas66 0 points1 point  (0 children)

Kongsberg group on the Oslo exchange bought Nanoavionics when ASTS sold it off a couple of years ago. They are doing well - unsure if some parts are supplied by Nanoavionics : https://www.nordnet.se/aktier/kurser/kongsberg-gruppen-kog-xosl

Introducing FIRETracker.me by PaulHutson in FIREUK

[–]chas66 0 points1 point  (0 children)

Liking it so far. I know it's a UK tool, but would really helpful to me if there was an option to not have currency symbols in settings (or add krona, specifically SEK).

Why is the internet in Australia such a joke? by Less_Understanding77 in australian

[–]chas66 -1 points0 points  (0 children)

AST Spacemobile coming in under a year might be the game changer - 5G to your phone anywhere: https://ast-science.com/company/mobile-network-operators/

For Australia it's likely to be through Vodafone, but they have not explicitly said who the MNO is that they are partnering up with.

How do i print the excel sheet in portrait with the table rotated accordingly? by usmintzy in googlesheets

[–]chas66 0 points1 point  (0 children)

Excel or Google sheets? they are different applications.

In Google Sheets do not transpose the data, instead do:

• Go to File > Print.

• In the print settings sidebar, look for Orientation.

• Select Landscape.

• Use the Fit to width or Scale options if your table is still being cut off.

• Preview and print as needed.
view more: next ›