Selasa, 07 Juli 2015

[smf_addin] Digest Number 3450

5 Messages

Digest #3450
1a
FRED CSV by zacharycal
1b
Re: FRED CSV by "Randy Harmelink" rharmelink
1c
Re: FRED CSV by "Randy Harmelink" rharmelink
1d
Re: FRED CSV by zacharycal

Messages

Mon Jul 6, 2015 8:22 am (PDT) . Posted by:

zacharycal

Hey Randy,


Quick question. I have been running this economic report for over a year now and all my CSV downloads from FRED have worked perfectly until today.


I was using this as my formula: =smfGetCSVFile(http://research.stlouisfed.org/fred2/data/PERMIT.csv) http://research.stlouisfed.org/fred2/data/PERMIT.csv) and it's not working now. I should also add that other add in formulas for other sites (Yahoo stock history, get HTML table) are working. Any thoughts?

Thanks,


Zach



Mon Jul 6, 2015 9:26 am (PDT) . Posted by:

"Randy Harmelink" rharmelink

It looks like they've changed it so that the file is created on the fly
instead of physically sitting on the server for the function to retrieve.

On Mon, Jul 6, 2015 at 8:22 AM, zabrams@... wrote:

> Quick question. I have been running this economic report for over a
> year now and all my CSV downloads from FRED have worked perfectly until
> today.
>
> I was using this as my formula: =smfGetCSVFile(
> http://research.stlouisfed.org/fred2/data/PERMIT.csv) and it's not
> working now. I should also add that other add in formulas for other sites
> (Yahoo stock history, get HTML table) are working. Any thoughts?
>
>

Mon Jul 6, 2015 9:30 am (PDT) . Posted by:

"Randy Harmelink" rharmelink

Ahhh...they changed the URL of the file. It now requires the "https:"
protocol. Try:

=smfGetCSVFile("https://research.stlouisfed.org/fred2/data/PERMIT.csv")

On Mon, Jul 6, 2015 at 8:22 AM, zabrams@capitaladvisorsltd.com [smf_addin] <
smf_addin@yahoogroups.com> wrote:

> Quick question. I have been running this economic report for over a
> year now and all my CSV downloads from FRED have worked perfectly until
> today.
>
> I was using this as my formula: =smfGetCSVFile(
> http://research.stlouisfed.org/fred2/data/PERMIT.csv) and it's not
> working now. I should also add that other add in formulas for other sites
> (Yahoo stock history, get HTML table) are working. Any thoughts?
>
>

Mon Jul 6, 2015 9:41 am (PDT) . Posted by:

zacharycal

Awesome Randy. Thanks! Figured it was something that small but couldn't figure it out. Hope you had a great 4th!
Zach

Mon Jul 6, 2015 12:36 pm (PDT) . Posted by:

rdenotari

I'm in the same boat. Would love to have a working GF file. The 2003 version has the same problem for me.
For the Add-in, Documentation, Templates, Tips and FAQs, visit http://ogres-crypt.com/SMF

Tidak ada komentar:

Poskan Komentar