Thank you Villeroy. You gave me the bit I needed! (at least untill yahoo &%#@s it up again)

So, to put it all together...

To get stock quotes in Libre Office without using an extension, you can use the following...

Enter into a cell:

=NUMBERVALUE(WEBSERVICE("http://download.finance.yahoo.com/d/quotes?s="&U4&"&f=l1");".")

where U4 is the cell that contains a stock symbol

Alternatively, the stock symbol can be put directly in place of the cell reference surrounded by double quotes (eg &"BGM.V"&) instead of (&U4&)

The l1 (Last Trade (Price Only)) in the statement can be replaced with the following, depending on what information you want displayed. (eg: instead of f=l1 make it f=c1 (change))

***

Financial Data you can Download (brazenly swiped from

http://www.jarloo.com/yahoo_finance/)

Pricing Dividends

a: Ask y: Dividend Yield

b: Bid d: Dividend per Share

b2: Ask (Realtime) r1: Dividend Pay Date

b3: Bid (Realtime) q: Ex-Dividend Date

p: Previous Close

o: Open

Date

c1: Change d1: Last Trade Date

c: Change & Percent Change d2: Trade Date

c6: Change (Realtime) t1: Last Trade Time

k2: Change Percent (Realtime)

p2: Change in Percent

Averages

c8: After Hours Change (Realtime) m5: Change From 200 Day Moving Average

c3: Commission m6: Percent Change From 200 Day Moving Average

g: Day’s Low m7: Change From 50 Day Moving Average

h: Day’s High m8: Percent Change From 50 Day Moving Average

k1: Last Trade (Realtime) With Time m3: 50 Day Moving Average

l: Last Trade (With Time) m4: 200 Day Moving Average

l1: Last Trade (Price Only)

t8: 1 yr Target Price

Misc

w1: Day’s Value Change g1: Holdings Gain Percent

w4: Day’s Value Change (Realtime) g3: Annualized Gain

p1: Price Paid g4: Holdings Gain

m: Day’s Range g5: Holdings Gain Percent (Realtime)

m2: Day’s Range (Realtime) g6: Holdings Gain (Realtime)

52 Week Pricing Symbol Info

k: 52 Week High i: More Info

j: 52 week Low j1: Market Capitalization

j5: Change From 52 Week Low j3: Market Cap (Realtime)

k4: Change From 52 week High f6: Float Shares

j6: Percent Change From 52 week Low n: Name

k5: Percent Change From 52 week High n4: Notes

w: 52 week Range s: Symbol

s1: Shares Owned

x: Stock Exchange

j2: Shares Outstanding

Volume Misc

v: Volume

a5: Ask Size t7: Ticker Trend

b6: Bid Size Misc t6: Trade Links

k3: Last Trade Size i5: Order Book (Realtime)

a2: Average Daily Volume l2: High Limit

l3: Low Limit

v1: Holdings Value

v7: Holdings Value (Realtime)

Ratios s6: Revenue

e: Earnings per Share

e7: EPS Estimate Current Year

e8: EPS Estimate Next Year

e9: EPS Estimate Next Quarter

b4: Book Value

j4: EBITDA

p5: Price / Sales

p6: Price / Book

r: P/E Ratio

r2: P/E Ratio (Realtime)

r5: PEG Ratio

r6: Price / EPS Estimate Current Year

r7: Price / EPS Estimate Next Year

s7: Short Ratio

All I can say is, it's working for me.