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/quo ... &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.