Brilliant Filipe, thanks for this!

C

On Fri, 3 Apr 2020 at 10:45, F.R.Costa <filipe@pobox.io> wrote:
Hi guys,

Just as an update on the script to retrieve covid-19 data from ECDC. This one works:

<hansl>
string site = "https://www.ecdc.europa.eu/sites/default/files/documents/COVID-19-geographic-disbtribution-worldwide-"
string fname = "2020-04-02.xlsx"
string URL = site ~ fname
open @URL --quiet
setobs countriesAndTerritories dateRep --panel-vars
</hansl>

In the string fname, you need to change manually for the date you wish in the format yyyy-mm-dd or eventually use some gretl function to update the date to current day automatically.

Best wishes and stay safe!

F.R.Costa
--
Securely sent with Tutanota. Get your own encrypted, ad-free mailbox:
https://tutanota.com



Mar 22, 2020, 18:02 by clivelists@googlemail.com:
Precisely!

C

On Sun, 22 Mar 2020 at 12:18, Allin Cottrell <cottrell@wfu.edu> wrote:
On Sun, 22 Mar 2020, Sven Schreiber wrote:

> Am 22.03.2020 um 10:52 schrieb Clive Nicholas:
>> But not for me, irritatingly (mine is up to date, and I can open .xlsx
>> files through LibreOffice):
>>
>> gretl version 2020b-git
>> Current session: 2020-03-22 09:38
>>
>> Generated string site
>> ? string fname =
>> "COVID-19-geographic-distribution-worldwide-2020-03-21.xlsx"
>
> I think Allin's point was that there's a typo in the file name which you
> have to copy verbatim, while you corrected it automatically?

Yes. Jack faithfully transcribed the mis-spelled "disbtribution" in
the link, and if you "correct" the spelling (as Clive apparently
did) the link won't work.

Allin
_______________________________________________
Gretl-users mailing list -- gretl-users@gretlml.univpm.it
To unsubscribe send an email to gretl-users-leave@gretlml.univpm.it


--
Clive Nicholas

"My colleagues in the social sciences talk a great deal about methodology. I prefer to call it style." -- Freeman J. Dyson

_______________________________________________
Gretl-users mailing list -- gretl-users@gretlml.univpm.it
To unsubscribe send an email to gretl-users-leave@gretlml.univpm.it
Website: https://gretlml.univpm.it/postorius/lists/gretl-users.gretlml.univpm.it/


--
Clive Nicholas

"My colleagues in the social sciences talk a great deal about methodology. I prefer to call it style." -- Freeman J. Dyson