8 Messages
Digest #3428
Messages
Mon Jun 8, 2015 3:54 am (PDT) . Posted by:
kohl.fred
Hey everyone,
As I have not found anyone with the same problem yet, I thought I'd just start a new topic.
So when I installed the addin (Win 7, Excel 2007) it all worked perfectly fine apart from the fact that the RCHGetYahooQuotes() Function would return 5 and occasionally 4 digit values. Is there any way to fix this? I tried dividing by 1000 but that does not always do the trick.
When I downloaded an example from the Website I found the same problem :(
Regardsm
Freddy
As I have not found anyone with the same problem yet, I thought I'd just start a new topic.
So when I installed the addin (Win 7, Excel 2007) it all worked perfectly fine apart from the fact that the RCHGetYahooQuotes(
When I downloaded an example from the Website I found the same problem :(
Regardsm
Freddy
Mon Jun 8, 2015 3:58 am (PDT) . Posted by:
"Randy Harmelink" rharmelink
It's probably because you don't have US regional settings on your system?
In any case, the data comes in just as Yahoo sends it. No translation of
any type is done. It just drops the text data into the cell and EXCEL
interprets it as text or numeric and does the conversion as necessary.
On Mon, Jun 8, 2015 at 2:55 AM, kohl.fred@... wrote:
> As I have not found anyone with the same problem yet, I thought I'd just
> start a new topic.
>
> So when I installed the addin (Win 7, Excel 2007) it all worked perfectly
> fine apart from the fact that the RCHGetYahooQuotes() Function would return
> 5 and occasionally 4 digit values. Is there any way to fix this? I tried
> dividing by 1000 but that does not always do the trick.
>
> When I downloaded an example from the Website I found the same problem :(
>
>
In any case, the data comes in just as Yahoo sends it. No translation of
any type is done. It just drops the text data into the cell and EXCEL
interprets it as text or numeric and does the conversion as necessary.
On Mon, Jun 8, 2015 at 2:55 AM, kohl.fred@..
> As I have not found anyone with the same problem yet, I thought I'd just
> start a new topic.
>
> So when I installed the addin (Win 7, Excel 2007) it all worked perfectly
> fine apart from the fact that the RCHGetYahooQuotes(
> 5 and occasionally 4 digit values. Is there any way to fix this? I tried
> dividing by 1000 but that does not always do the trick.
>
> When I downloaded an example from the Website I found the same problem :(
>
>
Mon Jun 8, 2015 3:55 am (PDT) . Posted by:
"Fred Kohl" kohl.fred
Hey there,
Unfortunately all the data I retrieve is formatted in the wrong way. The decimals never work. I usually get 5 digit stock prices for stocks that are worth only in the 2 digits. Occasionally I retrieve 6 digit prices for the same stocks. I am using a German version of excel on Win7.Has any1 got an Idea how I can fix this?Even when I use templates this formatting error occurs with all numbers.
Regards, Freddy
Unfortunately all the data I retrieve is formatted in the wrong way. The decimals never work. I usually get 5 digit stock prices for stocks that are worth only in the 2 digits. Occasionally I retrieve 6 digit prices for the same stocks. I am using a German version of excel on Win7.Has any1 got an Idea how I can fix this?Even when I use templates this formatting error occurs with all numbers.
Regards, Freddy
Mon Jun 8, 2015 8:11 am (PDT) . Posted by:
sirons1962
Does anyone know if there is a way to get the 10 Year Quarterly data into a spreadsheet? I am a premium member and I can click on the P 10-Y Quarterly View and it opens up another window with the data in it, I just can't seem to be able to extract it.
Thanks.
Thanks.
Mon Jun 8, 2015 10:40 am (PDT) . Posted by:
"Randy Harmelink" rharmelink
They have a CSV file you can grab that has 15 annual periods + TTM + 60
quarterly periods. However, I had to make a "fix" to my code because they
had a comma field in the middle of a comma-delimited file and it caused my
parsing routine to hiccup. So you would need this updated add-in file from
the "Works in Progress" folder on the SMF add-in website for the CSV file:
RCH_Stock_Market_Functions-2.1.2015.06.08.zip
<http://ogres-crypt.com/SMF/Works-In-Progress/RCH_Stock_Market_Functions-2.1.2015.06.08.zip>
With that, I can grab the CSV file with something like:
=smfGetCSVFile("
http://www.gurufocus.com/download_financials_in_CSV.php?symbol="&B2)
Another option would be to pull the XLS file yourself. An example of the
VBA code for that is here:
https://groups.yahoo.com/neo/groups/smf_addin/conversations/messages/25737
On Mon, Jun 8, 2015 at 8:11 AM, sirons1962@yahoo.com [smf_addin] <
smf_addin@yahoogroups.com> wrote:
>
> Does anyone know if there is a way to get the 10 Year Quarterly data into
> a spreadsheet? I am a premium member and I can click on the P 10-Y
> Quarterly View and it opens up another window with the data in it, I just
> can't seem to be able to extract it.
>
>
quarterly periods. However, I had to make a "fix" to my code because they
had a comma field in the middle of a comma-delimited file and it caused my
parsing routine to hiccup. So you would need this updated add-in file from
the "Works in Progress" folder on the SMF add-in website for the CSV file:
RCH_Stock_Market_Functions-2.1.2015.06.08.zip
<http://ogres-crypt.com/SMF/Works-In-Progress/RCH_Stock_Market_Functions-2.1.2015.06.08.zip>
With that, I can grab the CSV file with something like:
=smfGetCSVFile("
http://www.gurufocus.com/download_financials_in_CSV.php?symbol="&B2)
Another option would be to pull the XLS file yourself. An example of the
VBA code for that is here:
https://groups.yahoo.com/neo/groups/smf_addin/conversations/messages/25737
On Mon, Jun 8, 2015 at 8:11 AM, sirons1962@yahoo.com [smf_addin] <
smf_addin@yahoogroups.com> wrote:
>
> Does anyone know if there is a way to get the 10 Year Quarterly data into
> a spreadsheet? I am a premium member and I can click on the P 10-Y
> Quarterly View and it opens up another window with the data in it, I just
> can't seem to be able to extract it.
>
>
Mon Jun 8, 2015 1:02 pm (PDT) . Posted by:
sirons1962
Thanks Randy!
I updated the add-in file so I could attempt the CSV retrieval but is it coming up with some errors and shows only limited headers and no data.
Here is what I am seeing:
<br /> <b>Warning</b>: array_keys() expects parameter 1 to be array
<br />
<b>Warning</b>: Invalid argument supplied for foreach() in <b>/home/gurufocu/public_html/download_financials_in_CSV.php</b> on line <b>170</b><br /> <br /> <b>Warning</b>: array_keys() expects parameter 1 to be array <br /> <b>Warning</b>: Invalid argument supplied for foreach() in <b>/home/gurufocu/public_html/download_financials_in_CSV.php</b> on line <b>179</b><br />
Any ideas?
---In smf_addin@yahoogroups.com, <rharmelink@...> wrote :
They have a CSV file you can grab that has 15 annual periods + TTM + 60 quarterly periods. However, I had to make a "fix" to my code because they had a comma field in the middle of a comma-delimited file and it caused my parsing routine to hiccup. So you would need this updated add-in file from the "Works in Progress" folder on the SMF add-in website for the CSV file:
RCH_Stock_Market_Functions-2.1.2015.06.08.zip http://ogres-crypt.com/SMF/Works-In-Progress/RCH_Stock_Market_Functions-2.1.2015.06.08.zip
With that, I can grab the CSV file with something like:
=smfGetCSVFile("http://www.gurufocus.com/download_financials_in_CSV.php?symbol= http://www.gurufocus.com/download_financials_in_CSV.php?symbol="&B2)
Another option would be to pull the XLS file yourself. An example of the VBA code for that is here:
https://groups.yahoo.com/neo/groups/smf_addin/conversations/messages/25737 https://groups.yahoo.com/neo/groups/smf_addin/conversations/messages/25737
On Mon, Jun 8, 2015 at 8:11 AM, sirons1962@... mailto:sirons1962@... [smf_addin] <smf_addin@yahoogroups.com mailto:smf_addin@yahoogroups.com> wrote:
Does anyone know if there is a way to get the 10 Year Quarterly data into a spreadsheet? I am a premium member and I can click on the P 10-Y Quarterly View and it opens up another window with the data in it, I just can't seem to be able to extract it.
I updated the add-in file so I could attempt the CSV retrieval but is it coming up with some errors and shows only limited headers and no data.
Here is what I am seeing:
<br /> <b>Warning</b>: array_keys() expects parameter 1 to be array
<br />
<b>Warning</b>: Invalid argument supplied for foreach() in <b>/home/gurufocu/public_html/download_financials_in_CSV.php</b> on line <b>170</b><br /> <br /> <b>Warning</b>: array_keys() expects parameter 1 to be array <br /> <b>Warning</b>: Invalid argument supplied for foreach() in <b>/home/gurufocu/public_html/download_financials_in_CSV.php</b> on line <b>179</b><br />
Any ideas?
---In smf_addin@yahoogroups.com, <rharmelink@...> wrote :
They have a CSV file you can grab that has 15 annual periods + TTM + 60 quarterly periods. However, I had to make a "fix" to my code because they had a comma field in the middle of a comma-delimited file and it caused my parsing routine to hiccup. So you would need this updated add-in file from the "Works in Progress" folder on the SMF add-in website for the CSV file:
RCH_Stock_Market_Functions-2.1.2015.06.08.zip http://ogres-crypt.com/SMF/Works-In-Progress/RCH_Stock_Market_Functions-2.1.2015.06.08.zip
With that, I can grab the CSV file with something like:
=smfGetCSVFile("http://www.gurufocus.com/download_financials_in_CSV.php?symbol= http://www.gurufocus.com/download_financials_in_CSV.php?symbol="&B2)
Another option would be to pull the XLS file yourself. An example of the VBA code for that is here:
https://groups.yahoo.com/neo/groups/smf_addin/conversations/messages/25737 https://groups.yahoo.com/neo/groups/smf_addin/conversations/messages/25737
On Mon, Jun 8, 2015 at 8:11 AM, sirons1962@... mailto:sirons1962@... [smf_addin] <smf_addin@yahoogroups.com mailto:smf_addin@yahoogroups.com> wrote:
Does anyone know if there is a way to get the 10 Year Quarterly data into a spreadsheet? I am a premium member and I can click on the P 10-Y Quarterly View and it opens up another window with the data in it, I just can't seem to be able to extract it.
Mon Jun 8, 2015 1:50 pm (PDT) . Posted by:
"Randy Harmelink" rharmelink
To answer your original question, which I just now understand (I never
about the premium "P 10Y Quarterly" view link) -- the 10-year quarterly
data is in these IFRAMES, so you could extract from there:
http://www.gurufocus.com/modules/financials/quarterly_iframe.php?symbol=MCD&is
http://www.gurufocus.com/modules/financials/quarterly_iframe.php?symbol=MCD&bs
http://www.gurufocus.com/modules/financials/quarterly_iframe.php?symbol=MCD&cf
But the tables are not fully coded in HTML, so RCHGetTableCell() will not
work. An extraction would look something like:
=smfConvertData(smfGetTagContent("
http://www.gurufocus.com/modules/financials/quarterly_iframe.php?symbol=MCD&is
","td",1,">Revenue"))
On Mon, Jun 8, 2015 at 8:11 AM, sirons1962@yahoo.com [smf_addin] <
smf_addin@yahoogroups.com> wrote:
>
> Does anyone know if there is a way to get the 10 Year Quarterly data into
> a spreadsheet? I am a premium member and I can click on the P 10-Y
> Quarterly View and it opens up another window with the data in it, I just
> can't seem to be able to extract it.
>
about the premium "P 10Y Quarterly" view link) -- the 10-year quarterly
data is in these IFRAMES, so you could extract from there:
http://www.gurufocus.com/modules/financials/quarterly_iframe.php?symbol=MCD&is
http://www.gurufocus.com/modules/financials/quarterly_iframe.php?symbol=MCD&bs
http://www.gurufocus.com/modules/financials/quarterly_iframe.php?symbol=MCD&cf
But the tables are not fully coded in HTML, so RCHGetTableCell() will not
work. An extraction would look something like:
=smfConvertData(smfGetTagContent("
http://www.gurufocus.com/modules/financials/quarterly_iframe.php?symbol=MCD&is
","td",1,">Revenue"))
On Mon, Jun 8, 2015 at 8:11 AM, sirons1962@yahoo.com [smf_addin] <
smf_addin@yahoogroups.com> wrote:
>
> Does anyone know if there is a way to get the 10 Year Quarterly data into
> a spreadsheet? I am a premium member and I can click on the P 10-Y
> Quarterly View and it opens up another window with the data in it, I just
> can't seem to be able to extract it.
>
Mon Jun 8, 2015 1:56 pm (PDT) . Posted by:
"Randy Harmelink" rharmelink
Those appear to be PHP error messages, being generated as a web page. So
it's not creating the CSV file for you...?
Have you created an IE security cookie for EXCEL and the add-in to use?
You'll need to log in to GuruFocus using either the EXCEL Web Query dialog
(alt+d+d+w) or using IE.
I'll attach a copy of a quick template I threw together.
On Mon, Jun 8, 2015 at 1:02 PM, sirons1962@yahoo.com [smf_addin] <
smf_addin@yahoogroups.com> wrote:
>
>
> Thanks Randy!
>
> I updated the add-in file so I could attempt the CSV retrieval but is it
> coming up with some errors and shows only limited headers and no data.
>
> Here is what I am seeing:
>
> <br /> <b>Warning<;/b>: array_keys() expects parameter 1 to be array
> <br />
> <b>Warning<;/b>: Invalid argument supplied for foreach() in
> <b>/home/gurufocu/public_html/download_financials_in_CSV.php</b> on line
> <b>170</b><br /> <br /> <b>Warning<;/b>: array_keys() expects parameter
> 1 to be array <br /> <b>Warning<;/b>: Invalid argument supplied for
> foreach() in
> <b>/home/gurufocu/public_html/download_financials_in_CSV.php</b> on line
> <b>179</b><br />
>
> Any ideas?
>
it's not creating the CSV file for you...?
Have you created an IE security cookie for EXCEL and the add-in to use?
You'll need to log in to GuruFocus using either the EXCEL Web Query dialog
(alt+d+d+w) or using IE.
I'll attach a copy of a quick template I threw together.
On Mon, Jun 8, 2015 at 1:02 PM, sirons1962@yahoo.com [smf_addin] <
smf_addin@yahoogroups.com> wrote:
>
>
> Thanks Randy!
>
> I updated the add-in file so I could attempt the CSV retrieval but is it
> coming up with some errors and shows only limited headers and no data.
>
> Here is what I am seeing:
>
> <br /> <b>Warning<
> <br />
> <b>Warning<
> <b>/home/
> <b>170<
> 1 to be array <br /> <b>Warning<
> foreach() in
> <b>/home/
> <b>179<
>
> Any ideas?
>
Attachment(s) from Randy Harmelink
1 of 1 File(s)
For the Add-in, Documentation, Templates, Tips and FAQs, visit http://ogres-crypt.com/SMF
Tidak ada komentar:
Posting Komentar