9 New Messages
Digest #2830
Messages
Mon Oct 28, 2013 7:25 am (PDT) . Posted by:
"Kermit W. Prather" kermitpra
As usual you are correct, I did report it as you said.
I just tried it on another machine and it works fine.
Apparently, I have some sort of IE problem on my Vista 64-bit machine.
If you remember I also have a major problem that very little of the MSN elements work on this machine.
Sorry, to be redundant.
Kermit
From: smf_addin@yahoogroups.com [mailto:smf_addin@yahoogroups.com] On Behalf Of Randy Harmelink
Sent: Sunday, October 27, 2013 3:32 PM
To: smf_addin@yahoogroups.com
Subject: Re: [smf_addin] Elements 811, 812, 813 return error
They work fine here. You reported this back in March. When we investigated, it turned out your web pages contained different content than mine. I don't know how to handle such a situation in an element definition.
See: http://groups.yahoo.com/neo/groups/smf_addin/conversations/messages/21724
On Sun, Oct 27, 2013 at 12:06 PM, Kermit W. Prather <kermitp@tampabay.rr.com> wrote:
When I retrieve the elements from Stockscores.com all seem to work except 811, 812, and 813 they return error on all symbols I tried.
The example below uses IBM as the symbol. All other Stockscores elements work okay.
811
StockScores
Price Indicator -- 100 Day Trend
Error
812
StockScores
Price Indicator -- 15 Day Trend
Error
813
StockScores
Price Indicator -- 45 Day Trend
Error
I Copied the 3 elements in question from the webpage they show the bearish move
Moving Average Indictors
15 Day Trend
Bearishbearish
45 Day Trend
Bearishbearish
100 Day Trend
Bearishbearish
Mid Term Moving Average Crossover
NONE
Long Term Moving Average Crossover
NONE
Kermit
I just tried it on another machine and it works fine.
Apparently, I have some sort of IE problem on my Vista 64-bit machine.
If you remember I also have a major problem that very little of the MSN elements work on this machine.
Sorry, to be redundant.
Kermit
From: smf_addin@yahoogrou
Sent: Sunday, October 27, 2013 3:32 PM
To: smf_addin@yahoogrou
Subject: Re: [smf_addin] Elements 811, 812, 813 return error
They work fine here. You reported this back in March. When we investigated, it turned out your web pages contained different content than mine. I don't know how to handle such a situation in an element definition.
See: http://groups.
On Sun, Oct 27, 2013 at 12:06 PM, Kermit W. Prather <kermitp@tampabay.
When I retrieve the elements from Stockscores.
The example below uses IBM as the symbol. All other Stockscores elements work okay.
811
StockScores
Price Indicator -- 100 Day Trend
Error
812
StockScores
Price Indicator -- 15 Day Trend
Error
813
StockScores
Price Indicator -- 45 Day Trend
Error
I Copied the 3 elements in question from the webpage they show the bearish move
Moving Average Indictors
15 Day Trend
Bearishbearish
45 Day Trend
Bearishbearish
100 Day Trend
Bearishbearish
Mid Term Moving Average Crossover
NONE
Long Term Moving Average Crossover
NONE
Kermit
Mon Oct 28, 2013 9:52 am (PDT) . Posted by:
"Lao Si" laosilok
Dear,
Would like to seek you advise on how to get the HK price quote
i try both
=smfGetAdvFNElement("005.hk","A",999)
and
=RCHGetYahooQuotes("005.hk")
but the result is
005.hk
and not able to get the quote
Please advise how to get it
tks
Cecilia
Would like to seek you advise on how to get the HK price quote
i try both
=smfGetAdvFNElement
and
=RCHGetYahooQuotes(
but the result is
005.hk
and not able to get the quote
Please advise how to get it
tks
Cecilia
Mon Oct 28, 2013 11:43 am (PDT) . Posted by:
"Randy Harmelink" rharmelink
First of all, 005.hk is not a valid ticker symbol on either AdvFN or Yahoo.
And, this formula:
=smfGetADVFNElement("MMM","A",999)
...would tell me how many annual periods of financials are available on
AdvFN for ticker "MMM", so I'm not sure why you were trying to use it for a
price quote. I'm not sure AdvFN has financial statements data on Hong Kong
stocks?
I tried this:
=RCHGetYahooQuotes("0059.HK")
...and was able to get current quotes from Yahoo. However, it needs to be
array-entered over a range that is sized one row and up to nine columns
(the default is to return nine different data items). If you enter it into
a single cell, you just get the FIRST value returned -- which is the ticker
symbol.
If all you want is the current price, you would just tell it to return that
data item:
=RCHGetYahooQuotes("0059.HK","l1")
The ticker symbol on AdvFN for "0059.HK" is "HKX:59", but AdvFN has no
financial statements data for it.
On Mon, Oct 28, 2013 at 9:52 AM, Lao Si <laosilok@yahoo.com> wrote:
>
> Would like to seek you advise on how to get the HK price quote
>
> i try both
> =smfGetAdvFNElement("005.hk","A",999)
>
> and
>
> =RCHGetYahooQuotes("005.hk")
>
> but the result is
> 005.hk
>
> and not able to get the quote
>
> Please advise how to get it
>
>
And, this formula:
=smfGetADVFNElement
...would tell me how many annual periods of financials are available on
AdvFN for ticker "MMM"
price quote. I'm not sure AdvFN has financial statements data on Hong Kong
stocks?
I tried this:
=RCHGetYahooQuotes(
...and was able to get current quotes from Yahoo. However, it needs to be
array-entered over a range that is sized one row and up to nine columns
(the default is to return nine different data items). If you enter it into
a single cell, you just get the FIRST value returned -- which is the ticker
symbol.
If all you want is the current price, you would just tell it to return that
data item:
=RCHGetYahooQuotes(
The ticker symbol on AdvFN for "0059.HK" is "HKX:59"
financial statements data for it.
On Mon, Oct 28, 2013 at 9:52 AM, Lao Si <laosilok@yahoo.
>
> Would like to seek you advise on how to get the HK price quote
>
> i try both
> =smfGetAdvFNElement
>
> and
>
> =RCHGetYahooQuotes(
>
> but the result is
> 005.hk
>
> and not able to get the quote
>
> Please advise how to get it
>
>
Mon Oct 28, 2013 8:54 pm (PDT) . Posted by:
lawrence.leesh
Hi Randy
When I use this formula
=RCHGetTableCell("http://www.marketwatch.com/investing/Stock/b20/financials?countrycode=SG",1,"Non Operating Income/Expense";) I get -5520.
When I use this formula
=RCHGetTableCell("http://www.marketwatch.com/investing/Stock/b20/financials?countrycode=SG",1,"Non-Operating Interest Income") I get 669436.
However, the -5520 is actually -5.52m while 669436 is less than seven hundred thousand. The returned results make the second number much bigger than the first when it is actually smaller.
Is there anything I can do to avoid this?
thanks
LL
When I use this formula
=RCHGetTableCell(
When I use this formula
=RCHGetTableCell(
However, the -5520 is actually -5.52m while 669436 is less than seven hundred thousand. The returned results make the second number much bigger than the first when it is actually smaller.
Is there anything I can do to avoid this?
thanks
LL
Mon Oct 28, 2013 9:29 pm (PDT) . Posted by:
"Randy Harmelink" rharmelink
The only way to avoid it would be to collect the raw data using
smfGetTagContent() instead of RCHGetTableCell(), and then convert the data
yourself. RCHGetTableCell() converts all magnitude suffixes into thousands
of dollars.
And, technically, your 669436 number is million of SGD, since that is what
the label on the table says:
"All values SGD millions."
On Mon, Oct 28, 2013 at 8:54 PM, <lawrence.leesh@yahoo.com> wrote:
> When I use this formula
>
> =RCHGetTableCell("
> http://www.marketwatch.com/investing/Stock/b20/financials?countrycode=SG",1,"Non
> Operating Income/Expense";) I get -5520.
>
> When I use this formula
>
> =RCHGetTableCell("
> http://www.marketwatch.com/investing/Stock/b20/financials?countrycode=SG",1,"Non-Operating
> Interest Income") I get 669436.
>
> However, the -5520 is actually -5.52m while 669436 is less than seven
> hundred thousand. The returned results make the second number much bigger
> than the first when it is actually smaller.
>
> Is there anything I can do to avoid this?
>
>
smfGetTagContent(
yourself. RCHGetTableCell(
of dollars.
And, technically, your 669436 number is million of SGD, since that is what
the label on the table says:
"All values SGD millions."
On Mon, Oct 28, 2013 at 8:54 PM, <lawrence.leesh@
> When I use this formula
>
> =RCHGetTableCell(
> http://www.marketwa
> Operating Income/Expense"
>
> When I use this formula
>
> =RCHGetTableCell(
> http://www.marketwa
> Interest Income"
>
> However, the -5520 is actually -5.52m while 669436 is less than seven
> hundred thousand. The returned results make the second number much bigger
> than the first when it is actually smaller.
>
> Is there anything I can do to avoid this?
>
>
Mon Oct 28, 2013 11:38 pm (PDT) . Posted by:
lawrence.leesh
I tried =smfGetTagContent("http://www.marketwatch.com/investing/Stock/b20/financials?countrycode=SG","td",1,"Non Operating Income/Expense";) and got <span class="mark... as the result.
Should it be something other than "td"? I modified this formula from an earlier conversation.
thanks
LL
---In smf_addin@yahoogroups.com, <rharmelink@...> wrote:
The only way to avoid it would be to collect the raw data using smfGetTagContent() instead of RCHGetTableCell(), and then convert the data yourself. RCHGetTableCell() converts all magnitude suffixes into thousands of dollars.
And, technically, your 669436 number is million of SGD, since that is what the label on the table says:
"All values SGD millions."
On Mon, Oct 28, 2013 at 8:54 PM, <lawrence.leesh@... mailto:lawrence.leesh@...> wrote:
When I use this formula =RCHGetTableCell("http://www.marketwatch.com/investing/Stock/b20/financials?countrycode=SG http://www.marketwatch.com/investing/Stock/b20/financials?countrycode=SG",1,"Non Operating Income/Expense";) I get -5520.
When I use this formula
=RCHGetTableCell("http://www.marketwatch.com/investing/Stock/b20/financials?countrycode=SG http://www.marketwatch.com/investing/Stock/b20/financials?countrycode=SG",1,"Non-Operating Interest Income") I get 669436.
However, the -5520 is actually -5.52m while 669436 is less than seven hundred thousand. The returned results make the second number much bigger than the first when it is actually smaller.
Is there anything I can do to avoid this?
Should it be something other than "td"
thanks
LL
---In smf_addin@yahoogrou
The only way to avoid it would be to collect the raw data using smfGetTagContent(
And, technically, your 669436 number is million of SGD, since that is what the label on the table says:
"All values SGD millions."
On Mon, Oct 28, 2013 at 8:54 PM, <lawrence.
When I use this formula =RCHGetTableCell(
When I use this formula
=RCHGetTableCell(
However, the -5520 is actually -5.52m while 669436 is less than seven hundred thousand. The returned results make the second number much bigger than the first when it is actually smaller.
Is there anything I can do to avoid this?
Tue Oct 29, 2013 12:05 am (PDT) . Posted by:
"Randy Harmelink" rharmelink
No, you got back what you should have. That's what the RCHGetTableCell()
function does. It starts with that string, removes all of the HTML markup
code, and then attempts to convert what is left into a number, adjusting as
necessary for the magnitude suffixes.
So you would need to do that processing yourself after grabbing the raw
contents of the table cell, as necessary.
In this particular case, you could grab the content of the "span" tag
inside that "td" tag, but I'm not sure how consistent that will be on the
web page:
=smfGetTagContent("
http://www.marketwatch.com/investing/Stock/b20/financials?countrycode=SG","span",1,"Non
Operating Income/Expense";)
On Mon, Oct 28, 2013 at 11:38 PM, <lawrence.leesh@yahoo.com> wrote:
> I tried =smfGetTagContent("
> http://www.marketwatch.com/investing/Stock/b20/financials?countrycode=SG","td",1,"Non
> Operating Income/Expense";) and got <span class="mark... as the result.
>
> Should it be something other than "td"? I modified this formula from an
> earlier conversation.
>
>
function does. It starts with that string, removes all of the HTML markup
code, and then attempts to convert what is left into a number, adjusting as
necessary for the magnitude suffixes.
So you would need to do that processing yourself after grabbing the raw
contents of the table cell, as necessary.
In this particular case, you could grab the content of the "span" tag
inside that "td" tag, but I'm not sure how consistent that will be on the
web page:
=smfGetTagContent(
http://www.marketwa
Operating Income/Expense"
On Mon, Oct 28, 2013 at 11:38 PM, <lawrence.leesh@
> I tried =smfGetTagContent(
> http://www.marketwa
> Operating Income/Expense"
>
> Should it be something other than "td"
> earlier conversation.
>
>
Mon Oct 28, 2013 9:50 pm (PDT) . Posted by:
"c1sander" c1sander
Randy,
Yes, I think this will do it. However, I get an error when I try it. I did go to the site and got an option quote first in IE (and left it open). Any suggestions?
Craig
--- In smf_addin@yahoogroups.com, Randy Harmelink <rharmelink@...> wrote:
>
> Is this what you want?
>
> =smfGet888OptionQuote("IBM",,,,"ivicc")
>
> Documentation for the function is in the "Works in Progress" folder. And
> you do need to get a quote manually from the website first (
> www.888options.com) using either the EXCEL Web Dialog or IE, so that the
> proper security cookie is created.
>
> On Sun, Oct 27, 2013 at 8:30 AM, Craig <craig.sander@...> wrote:
>
> >
> > Does anyone have suggestions for a site that can provide current Implied
> > Volatility for a given ticker or list of tickers?
> >
>
Yes, I think this will do it. However, I get an error when I try it. I did go to the site and got an option quote first in IE (and left it open). Any suggestions?
Craig
--- In smf_addin@yahoogrou
>
> Is this what you want?
>
> =smfGet888OptionQuo
>
> Documentation for the function is in the "Works in Progress" folder. And
> you do need to get a quote manually from the website first (
> www.888options.
> proper security cookie is created.
>
> On Sun, Oct 27, 2013 at 8:30 AM, Craig <craig.sander@
>
> >
> > Does anyone have suggestions for a site that can provide current Implied
> > Volatility for a given ticker or list of tickers?
> >
>
Mon Oct 28, 2013 10:27 pm (PDT) . Posted by:
"Randy Harmelink" rharmelink
Try doing it with your EXCEL Web Query dialog (alt+d+d+w), and then run the
smfForceRecalculation to force it to get a fresh copy of the web page.
Sometimes the version of the IE object used by EXCEL is different than the
browser.
Shouldn't need to leave anything open. It's the creation of the security
cookie that matters.
On Mon, Oct 28, 2013 at 9:50 PM, c1sander <craig.sander@comcast.net> wrote:
>
> Yes, I think this will do it. However, I get an error when I try it. I
> did go to the site and got an option quote first in IE (and left it open).
> Any suggestions?
>
smfForceRecalculati
Sometimes the version of the IE object used by EXCEL is different than the
browser.
Shouldn'
cookie that matters.
On Mon, Oct 28, 2013 at 9:50 PM, c1sander <craig.sander@
>
> Yes, I think this will do it. However, I get an error when I try it. I
> did go to the site and got an option quote first in IE (and left it open).
> Any suggestions?
>
Tidak ada komentar:
Posting Komentar