10 Messages
Digest #3146
Messages
Sat Aug 9, 2014 6:38 am (PDT) . Posted by:
tysongayada
hi randy,
tried to used it on a singapore stock exchange and i have pointed it to Cell A1
=RCHGetHTMLTable("http://quotes.wsj.com/SG/XSES/&A1&/financials/annual/income-statement","5-year trend<",-1,"",2)
http://quotes.wsj.com/SG/XSES/C6L/financials/annual/income-statement http://quotes.wsj.com/SG/XSES/C6L/financials/annual/income-statement
is there anything wrong with the formula?
tried to used it on a singapore stock exchange and i have pointed it to Cell A1
=RCHGetHTMLTable("http://quotes.wsj.com/SG/XSES/&A1&/financials/annual/income-statement","5-year trend<",-1,"",2)
http://quotes.wsj.com/SG/XSES/C6L/financials/annual/income-statement http://quotes.wsj.com/SG/XSES/C6L/financials/annual/income-statement
is there anything wrong with the formula?
Sat Aug 9, 2014 8:08 am (PDT) . Posted by:
"Randy Harmelink" rharmelink
You didn't point to cell A1 -- you added "&A1&" to the string literal. You
need to concatenate strings:
=RCHGetHTMLTable("http://quotes.wsj.com/SG/XSES/" & A1 &
"/financials/annual/income-statement","5-year trend<",-1,"",2)
On Sat, Aug 9, 2014 at 6:38 AM, tysongayada@yahoo.com [smf_addin] <
smf_addin@yahoogroups.com> wrote:
>
> tried to used it on a singapore stock exchange and i have pointed it to
> Cell A1
>
> =RCHGetHTMLTable("
> http://quotes.wsj.com/SG/XSES/&A1&/financials/annual/income-statement","5-year
> trend<",-1,"",2)
>
> http://quotes.wsj.com/SG/XSES/C6L/financials/annual/income-statement
>
> is there anything wrong with the formula?
>
need to concatenate strings:
=RCHGetHTMLTable("http://quotes.wsj.com/SG/XSES/" & A1 &
"/financials/annual/income-statement","5-year trend<",-1,"",2)
On Sat, Aug 9, 2014 at 6:38 AM, tysongayada@yahoo.com [smf_addin] <
smf_addin@yahoogroups.com> wrote:
>
> tried to used it on a singapore stock exchange and i have pointed it to
> Cell A1
>
> =RCHGetHTMLTable("
> http://quotes.wsj.com/SG/XSES/&A1&/financials/annual/income-statement","5-year
> trend<",-1,"",2)
>
> http://quotes.wsj.com/SG/XSES/C6L/financials/annual/income-statement
>
> is there anything wrong with the formula?
>
Sat Aug 9, 2014 8:40 am (PDT) . Posted by:
tysongayada
hi randy,
i did what you have said earlier on.
that means for example, the formula should be
=RCHGetHTMLTable("http://quotes.wsj.com/SG/XSES/"&A1&"/financials/annual/income-statement","5-year trend<",-1,"",2)
however, it is not showing any data.
i tried using
=RCHGetHTMLTable("http://quotes.wsj.com/SG/XSES/500/financials/annual/income-statement","5-year trend<",-1,"",2)
which points straight to a stock.
but it is also not showing any data.
any reason for that?
i did what you have said earlier on.
that means for example, the formula should be
=RCHGetHTMLTable("http://quotes.wsj.com/SG/XSES/"&A1&"/financials/annual/income-statement","5-year trend<",-1,"",2)
however, it is not showing any data.
i tried using
=RCHGetHTMLTable("http://quotes.wsj.com/SG/XSES/500/financials/annual/income-statement","
which points straight to a stock.
but it is also not showing any data.
any reason for that?
Sat Aug 9, 2014 9:02 am (PDT) . Posted by:
"Randy Harmelink" rharmelink
Don't know what's wrong -- both worked fine for me.
On Sat, Aug 9, 2014 at 8:40 AM, tysongayada@... wrote:
>
> i did what you have said earlier on.
>
> that means for example, the formula should be
>
> =RCHGetHTMLTable("http://quotes.wsj.com/SG/XSES/"&A1&"/financials/annual/income-statement","5-year
> trend<",-1,"",2)
>
> however, it is not showing any data.
>
> i tried using
>
> =RCHGetHTMLTable("
> http://quotes.wsj.com/SG/XSES/500/financials/annual/income-statement","5-year
> trend<",-1,"",2)
>
> which points straight to a stock.
>
> but it is also not showing any data.
>
> any reason for that?
>
On Sat, Aug 9, 2014 at 8:40 AM, tysongayada@... wrote:
>
> i did what you have said earlier on.
>
> that means for example, the formula should be
>
> =RCHGetHTMLTable("http://quotes.wsj.com/SG/XSES/"&A1&"/financials/annual/income-statement","5-year
> trend<",-1,"",2)
>
> however, it is not showing any data.
>
> i tried using
>
> =RCHGetHTMLTable("
> http://quotes.wsj.com/SG/XSES/500/financials/annual/income-statement","
> trend<"
>
> which points straight to a stock.
>
> but it is also not showing any data.
>
> any reason for that?
>
Sat Aug 9, 2014 6:57 pm (PDT) . Posted by:
tysongayada
hi randy,
i was experimenting and i found a sort of bug.
i have placed a list of rchgetyahooquotes on a few tabs in a xlsx worksheet along with the wsj rchgettable.
it is not able to pick up any data in the same worksheet.
however, when i placed the rchgettable quote in a new worksheet, the datas are picking up.
any comments on that?
i was experimenting and i found a sort of bug.
i have placed a list of rchgetyahooquotes on a few tabs in a xlsx worksheet along with the wsj rchgettable.
it is not able to pick up any data in the same worksheet.
however, when i placed the rchgettable quote in a new worksheet, the datas are picking up.
any comments on that?
Sat Aug 9, 2014 7:15 pm (PDT) . Posted by:
"Randy Harmelink" rharmelink
I don't see how that would happen. Can you attach an example?
On Sat, Aug 9, 2014 at 6:57 PM, tysongayada@yahoo.com [smf_addin] <
smf_addin@yahoogroups.com> wrote:
>
> i was experimenting and i found a sort of bug.
>
> i have placed a list of rchgetyahooquotes on a few tabs in a xlsx
> worksheet along with the wsj rchgettable.
>
> it is not able to pick up any data in the same worksheet.
>
> however, when i placed the rchgettable quote in a new worksheet, the datas
> are picking up.
>
> any comments on that?
>
On Sat, Aug 9, 2014 at 6:57 PM, tysongayada@yahoo.com [smf_addin] <
smf_addin@yahoogroups.com> wrote:
>
> i was experimenting and i found a sort of bug.
>
> i have placed a list of rchgetyahooquotes on a few tabs in a xlsx
> worksheet along with the wsj rchgettable.
>
> it is not able to pick up any data in the same worksheet.
>
> however, when i placed the rchgettable quote in a new worksheet, the datas
> are picking up.
>
> any comments on that?
>
Sat Aug 9, 2014 9:53 pm (PDT) . Posted by:
tysongayada
hi randy,
i think i found whats the reason. i found that when i opened 2 worksheets with WSJ rchgettables data, it is unable to extract datas for both the worksheets.
however, another problem arise.
as seen from the attached, when i tried to extract the balance sheet and cash flow from wsj,
there are a lot of missing datas when compared with the site's data
example such as Liabilities & Shareholders' Equity in the balance sheet and Financing Activities in the Cash Flow
I suspect it could be WSJ source code issue.
Is there any solution to the problem?
i think i found whats the reason. i found that when i opened 2 worksheets with WSJ rchgettables data, it is unable to extract datas for both the worksheets.
however, another problem arise.
as seen from the attached, when i tried to extract the balance sheet and cash flow from wsj,
there are a lot of missing datas when compared with the site's data
example such as Liabilities & Shareholders&#
I suspect it could be WSJ source code issue.
Is there any solution to the problem?
Attachment(s) from
1 of 1 File(s)
Sat Aug 9, 2014 10:05 pm (PDT) . Posted by:
"Randy Harmelink" rharmelink
The problem is that you didn't change the formula fully for the balance
sheet and the cash flow statement web pages.
The "5-year trend" is the starting search location. And -1 says to go back
one <table> tag to find the start of the table. Then the 2 says to go
forward two </table> tags from that same search term to find the end of the
table code to extract. So you're really extracting TWO tables.
But the cash flow page and balance sheet page of three tables. So you just
need to change the 2 parameter to a 3.
On Sat, Aug 9, 2014 at 9:53 PM, tysongayada@yahoo.com [smf_addin] <
smf_addin@yahoogroups.com> wrote:
>
> i think i found whats the reason. i found that when i opened 2 worksheets
> with WSJ rchgettables data, it is unable to extract datas for both the
> worksheets.
>
> however, another problem arise.
>
> as seen from the attached, when i tried to extract the balance sheet and
> cash flow from wsj,
> there are a lot of missing datas when compared with the site's data
>
> example such as Liabilities & Shareholders' Equity in the balance sheet
> and Financing Activities in the Cash Flow
>
> I suspect it could be WSJ source code issue.
>
> Is there any solution to the problem?
>
sheet and the cash flow statement web pages.
The "5-year trend" is the starting search location. And -1 says to go back
one <table> tag to find the start of the table. Then the 2 says to go
forward two </table> tags from that same search term to find the end of the
table code to extract. So you're really extracting TWO tables.
But the cash flow page and balance sheet page of three tables. So you just
need to change the 2 parameter to a 3.
On Sat, Aug 9, 2014 at 9:53 PM, tysongayada@yahoo.com [smf_addin] <
smf_addin@yahoogroups.com> wrote:
>
> i think i found whats the reason. i found that when i opened 2 worksheets
> with WSJ rchgettables data, it is unable to extract datas for both the
> worksheets.
>
> however, another problem arise.
>
> as seen from the attached, when i tried to extract the balance sheet and
> cash flow from wsj,
> there are a lot of missing datas when compared with the site's data
>
> example such as Liabilities & Shareholders&#
> and Financing Activities in the Cash Flow
>
> I suspect it could be WSJ source code issue.
>
> Is there any solution to the problem?
>
Sat Aug 9, 2014 7:35 am (PDT) . Posted by:
chrg
Hello,
=RCHGetYahooHistory doesn't work on a computer with french regional settings.
That's because of the decimal separator is a comma in french, causing the RCH function to fail (it returns blank values)...
Like for the smfgetoptionquotes function (not working for french users)...
Unless it is possible to change the regional settings inside VBA, I don't see any way to use any RCH function returning numbers in english format without modifying the addin's code.
Anyone with a solution?
All the best
Alex
=RCHGetYahooHistory doesn't work on a computer with french regional settings.
That's because of the decimal separator is a comma in french, causing the RCH function to fail (it returns blank values)...
Like for the smfgetoptionquotes function (not working for french users)...
Unless it is possible to change the regional settings inside VBA, I don't see any way to use any RCH function returning numbers in english format without modifying the addin's code.
Anyone with a solution?
All the best
Alex
Sun Aug 10, 2014 12:46 am (PDT) . Posted by:
chrg
Hello,
I suggest a patch in the "ConvertData" module of the addin to fix the bug experienced by users with a decimal separator regional setting = "," (comma) instead of the english ".".
For those users, no function of the addin works if the data is formatted with a decimal point (YAHOO GOOGLE etc...)
Here is the fix I propose: in the smfConvertData function, after line 31 ("On Error Resume Next"), insert the following line:
If Not IsNumeric(s2) Then s2 = Replace(s2, ".", ",")
That cannot harm anyone, since anyways, if s2 is not numeric, the cDec(s2) on the following line will fail.
And that bug happens for users with a decimal separator different from the english point.
Hope that helps (it works fine for me...)
Alex
I suggest a patch in the "ConvertData&q
For those users, no function of the addin works if the data is formatted with a decimal point (YAHOO GOOGLE etc...)
Here is the fix I propose: in the smfConvertData function, after line 31 ("On Error Resume Next"), insert the following line:
If Not IsNumeric(s2) Then s2 = Replace(s2, "."
That cannot harm anyone, since anyways, if s2 is not numeric, the cDec(s2) on the following line will fail.
And that bug happens for users with a decimal separator different from the english point.
Hope that helps (it works fine for me...)
Alex
For the Add-in, Documentation, Templates, Tips and FAQs, visit http://ogres-crypt.com/SMF
Tidak ada komentar:
Posting Komentar