3 Messages
Digest #3076
Messages
Mon May 26, 2014 12:49 pm (PDT) . Posted by:
ridgebacksexcel
I believe I found the thread you were referring to.
"Working backwards from a fixed string on Gurufocus"
I have tested one of the formulas and it seems to be working fine. I will adjust it to fit my spreadsheet's format and see if it checks out everywhere. I believe it will and fix a major bug I have been dealing with. Will let you know in a day or two how it worked out.
Thanks.
"Working backwards from a fixed string on Gurufocus"
I have tested one of the formulas and it seems to be working fine. I will adjust it to fit my spreadsheet&#
Thanks.
Mon May 26, 2014 9:17 pm (PDT) . Posted by:
kashyap_sunil
Hi Justin,
I am trying to pull the Gurufocus CSV file directly into Excel using the syntax you provided
=smfGetCSVFile("http://www.gurufocus.com/download_financials_in_CSV.php?symbol=AAPL")
All I get is one line "Downloaded from GuruFocus.com....."
None of the other cells populate. I think it has something to do with defining the array and I am not sure how to go about it. I did logon to the site through Excel. Can you let me know what I might be doing wrong. If you have a version that is working can you post it.
Thx
Neil
I am trying to pull the Gurufocus CSV file directly into Excel using the syntax you provided
=smfGetCSVFile("http://www.gurufocus.com/download_financials_in_CSV.php?symbol=AAPL")
All I get is one line "Downloaded from GuruFocus.com.
None of the other cells populate. I think it has something to do with defining the array and I am not sure how to go about it. I did logon to the site through Excel. Can you let me know what I might be doing wrong. If you have a version that is working can you post it.
Thx
Neil
Mon May 26, 2014 9:27 pm (PDT) . Posted by:
"Randy Harmelink" rharmelink
My guess would be that you're not array-entering the formula over a range?
Otherwise, it may no longer be a prepared file that is available for
download. They may prepare when you execute that URL.
On Mon, May 26, 2014 at 8:48 PM, kashyap_sunil@... wrote:
>
> I am trying to pull the Gurufocus CSV file directly into Excel using the
> syntax you provided
>
> =smfGetCSVFile("
> http://www.gurufocus.com/download_financials_in_CSV.php?symbol=AAPL")
>
> All I get is one line "Downloaded from GuruFocus.com....."
>
> None of the other cells populate. I think it has something to do with
> defining the array and I am not sure how to go about it. I did logon to
> the site through Excel. Can you let me know what I might be doing wrong.
> If you have a version that is working can you post it.
>
Otherwise, it may no longer be a prepared file that is available for
download. They may prepare when you execute that URL.
On Mon, May 26, 2014 at 8:48 PM, kashyap_sunil@... wrote:
>
> I am trying to pull the Gurufocus CSV file directly into Excel using the
> syntax you provided
>
> =smfGetCSVFile("
> http://www.gurufocus.com/download_financials_in_CSV.php?symbol=AAPL")
>
> All I get is one line "Downloaded from GuruFocus.com.
>
> None of the other cells populate. I think it has something to do with
> defining the array and I am not sure how to go about it. I did logon to
> the site through Excel. Can you let me know what I might be doing wrong.
> If you have a version that is working can you post it.
>
Tidak ada komentar:
Posting Komentar