Ask Your Question
0

How do I download web data such as finance.yahoo.com API

asked 2017-09-02 05:30:22 +0200

SFSecurity gravatar image

updated 2017-09-04 15:28:49 +0200

erAck gravatar image

I can't make HYPERLINK do more than =HYPERLINK(https:/finance.yahoo.com/d/quotes.csv)

I want to be able to use a link like this:

https://finance.yahoo.com/d/quotes.cs...

which I'm able to do by pasting the text directly into Firefox, but not with LibreOffice. I get a 510 error message and it wants me to shorten it to =HYPERLINK(https:/finance.yahoo.com/d/quotes.csv).

Clues?

edit retag flag offensive close merge delete

Comments

I can do HYPERLINK without problem. You should wrap link in quotation marks and you need two forward slashes: http://. You've missed that in your question so I made assumption that you've missed that in your spreadsheet. Does that solve your problem?

Kruno gravatar imageKruno ( 2017-09-02 14:35:38 +0200 )edit

1 Answer

Sort by » oldest newest most voted
0

answered 2017-09-04 15:27:24 +0200

erAck gravatar image

Use the SMF-Extension.

edit flag offensive delete link more
Login/Signup to Answer

Question Tools

1 follower

Stats

Asked: 2017-09-02 05:30:22 +0200

Seen: 538 times

Last updated: Sep 04 '17