Hi. I am working on a calc sheet and need to insert data from an url:
https://finance.google.com/finance/info?client=ig&q=NASDAQ%3aAAPL
I guess it generates a csv output (in the browser it is like:
// [ { "id": "22144" ,"t" : "AAPL" ,"e" : "NASDAQ" ,"l" : "99.92" ,"l_fix" :
"99.92" ,"l_cur" : "99.92" ,"s": "0" ,"ltt":"12:13PM EDT" ,"lt" : "Jul 18,
12:13PM EDT" ,"lt_dts" : "2016-07-18T12:13:44Z" ,"c" : "+1.14" ,"c_fix" :
"1.14" ,"cp" : "1.15" ,"cp_fix" : "1.15" ,"ccol" : "chg" ,"pcls_fix" : "98.78"
} ]). I would need to isolate the number with 'l' label and insert it into a
cell.
I also tried menu -> link external data -> url; it opens the page, sees the
table, but doesn't show it in the dialog box (with the checkbox 'update every x
seconds' .... bug??).
Thanks if you can help.
Paolo
--
To unsubscribe e-mail to: [email protected]
Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
List archive: http://listarchives.libreoffice.org/global/users/
All messages sent to this list will be publicly archived and cannot be deleted
