13 Messages
Digest #3145
5b
Re: problem extracting data for some tickers at MSN Stock Scouter we by "Randy Harmelink" rharmelink
Messages
Fri Aug 8, 2014 1:43 am (PDT) . Posted by:
"Randy Harmelink" rharmelink
The obsolete items aren't available on that web page. Those data items were
obsoleted when MSN dropped them from their web pages.
"None" just means there is no template that shows the use of that data
element. It doesn't mean the element can't be used. They should all be
available -- are you having problems with them?
On Fri, Aug 8, 2014 at 12:38 AM, mb0329@msn.com [smf_addin] <
smf_addin@yahoogroups.com> wrote:
>
> I notice that your RCHGetElementNumber for numbers 542 - 552 say none or
> obsolete. Why is this. Can't you get them at:
>
> StockScouter Rating System - MSN Money
> <http://investing.money.msn.com/investments/stock-ratings?symbol=t>
>
> as an example?
>
obsoleted when MSN dropped them from their web pages.
"None" just means there is no template that shows the use of that data
element. It doesn't mean the element can't be used. They should all be
available -- are you having problems with them?
On Fri, Aug 8, 2014 at 12:38 AM, mb0329@msn.com [smf_addin] <
smf_addin@yahoogroups.com> wrote:
>
> I notice that your RCHGetElementNumber for numbers 542 - 552 say none or
> obsolete. Why is this. Can't you get them at:
>
> StockScouter Rating System - MSN Money
> <http://investing.money.msn.com/investments/stock-ratings?symbol=t>
>
> as an example?
>
Fri Aug 8, 2014 5:38 am (PDT) . Posted by:
racecar00
So it looks like the issue is resolved. I did the following:
• EXCEL Web Query (alt+d+d+w) - http://finance.yahoo.com/q/ks?s=MMM http://finance.yahoo.com/q/ks?s=MMM: displayed correctly, no issues
• =smfGetTagContent("http://finance.yahoo.com/q/ks?s=MMM&x=1 http://finance.yahoo.com/q/ks?s=MMM&x=1","table",-1,">Market Cap") in new spreadsheet: displayed Error message
• IE setting: browser was displayed to check for new web pages each time
Your last suggestion got me thinking that this could be a browser issue (I hadn't even considered that) so I cleaned up all my temp files and deleted cookies, history, etc... and that was it!
Thanks for helping me on this issue, Randy!
• EXCEL Web Query (alt+d+d+w) - http://finance.yahoo.com/q/ks?s=MMM http://finance.yahoo.com/q/ks?s=MMM: displayed correctly, no issues
• =smfGetTagContent("http://finance.yahoo.com/q/ks?s=MMM&x=1 http://finance.yahoo.com/q/ks?s=MMM&x=1","
• IE setting: browser was displayed to check for new web pages each time
Your last suggestion got me thinking that this could be a browser issue (I hadn't even considered that) so I cleaned up all my temp files and deleted cookies, history, etc... and that was it!
Thanks for helping me on this issue, Randy!
Fri Aug 8, 2014 6:35 am (PDT) . Posted by:
chrg
Hello,
I am using excel 2013 on a desktop with windows 8.1 and french regional settings (decimal point is a comma etc...). I have problems with the "smfgetoptionquotes" function:
With "QQQ Aug 2014 92 C" as an argument, it works perfectly...
But if I try to get options quotes for a strike = 91.5$.
with "QQQ Aug 2014 91.50 C" I get an error "Bad strike price: 91.50"
If I use "QQQ Aug 2014 91,50 C" (comma decimal point) i get no result at all (blank cells)
What should I do ?
(I tried to change the "advanced";-"Use system spearators" option to no avail...)
Thanks for any answer,
Alex
I am using excel 2013 on a desktop with windows 8.1 and french regional settings (decimal point is a comma etc...). I have problems with the "smfgetoptionq
With "QQQ Aug 2014 92 C" as an argument, it works perfectly...
But if I try to get options quotes for a strike = 91.5$.
with "QQQ Aug 2014 91.50 C" I get an error "Bad strike price: 91.50"
If I use "QQQ Aug 2014 91,50 C" (comma decimal point) i get no result at all (blank cells)
What should I do ?
(I tried to change the "advanced"
Thanks for any answer,
Alex
Fri Aug 8, 2014 8:09 am (PDT) . Posted by:
"Randy Harmelink" rharmelink
I just tried:
=smfGetOptionQuotes("QQQ Aug 2014 91.50 C","b")
...and got back the $2.94 that shows up on my browser screen from Yahoo.
You must not be using Yahoo though -- I don't see a "Bad strike price"
message in the Yahoo option quotes module. But I tried it with the
OptionsXpress data source and also got a good bid price.
I suspect it is the French Regional setting that is causing the problem.
There is an ISNUMERIC() check in the VBA code. As I understand it, it will
use your regional settings to determine if the string is numeric or not.
I think the "system separators" setting only applies to EXCEL, and would
not affect the VBA environment.
On Fri, Aug 8, 2014 at 6:35 AM, al.plk@laposte... <al.plk@laposte.net>
wrote:
>
> I am using excel 2013 on a desktop with windows 8.1 and french regional
> settings (decimal point is a comma etc...). I have problems with the
> "smfgetoptionquotes" function:
>
> With "QQQ Aug 2014 92 C" as an argument, it works perfectly...
>
> But if I try to get options quotes for a strike = 91.5$.
>
> with "QQQ Aug 2014 91.50 C" I get an error "Bad strike price: 91.50"
> If I use "QQQ Aug 2014 91,50 C" (comma decimal point) i get no result at
> all (blank cells)
>
> What should I do ?
>
> (I tried to change the "advanced";-"Use system spearators" option to no
> avail...)
>
=smfGetOptionQuotes("QQQ Aug 2014 91.50 C","b")
...and got back the $2.94 that shows up on my browser screen from Yahoo.
You must not be using Yahoo though -- I don't see a "Bad strike price"
message in the Yahoo option quotes module. But I tried it with the
OptionsXpress data source and also got a good bid price.
I suspect it is the French Regional setting that is causing the problem.
There is an ISNUMERIC() check in the VBA code. As I understand it, it will
use your regional settings to determine if the string is numeric or not.
I think the "system separators" setting only applies to EXCEL, and would
not affect the VBA environment.
On Fri, Aug 8, 2014 at 6:35 AM, al.plk@laposte... <al.plk@laposte.net>
wrote:
>
> I am using excel 2013 on a desktop with windows 8.1 and french regional
> settings (decimal point is a comma etc...). I have problems with the
> "smfgetoptionq
>
> With "QQQ Aug 2014 92 C" as an argument, it works perfectly...
>
> But if I try to get options quotes for a strike = 91.5$.
>
> with "QQQ Aug 2014 91.50 C" I get an error "Bad strike price: 91.50"
> If I use "QQQ Aug 2014 91,50 C" (comma decimal point) i get no result at
> all (blank cells)
>
> What should I do ?
>
> (I tried to change the "advanced"
> avail...)
>
Fri Aug 8, 2014 10:43 am (PDT) . Posted by:
chrg
Thanks Randy,
The problem is: when you get to the ISNUMERIC() test, you check if "91.50" is numeric, which results in a FALSE answer because it is "91,50" (with a comma) that is numeric in the french environment.
The problem is that if you try to substitute the dot by a comma in the function argument, you get no answer (a blank).
Just like if there were a sort of validity check that rejects outright an argument with a comma instead of a dot as a decimal separator.
Is there a way in VBA to modify the system regional settings? (like you said, modifying the option in EXCEL doesn't seem to affect the VBA environment...)
The problem is: when you get to the ISNUMERIC() test, you check if "91.50" is numeric, which results in a FALSE answer because it is "91,50" (with a comma) that is numeric in the french environment.
The problem is that if you try to substitute the dot by a comma in the function argument, you get no answer (a blank).
Just like if there were a sort of validity check that rejects outright an argument with a comma instead of a dot as a decimal separator.
Is there a way in VBA to modify the system regional settings? (like you said, modifying the option in EXCEL doesn't seem to affect the VBA environment.
Fri Aug 8, 2014 10:47 am (PDT) . Posted by:
"Randy Harmelink" rharmelink
I don't know of a way to change the system's regional settings from within
VBA.
On Fri, Aug 8, 2014 at 10:43 AM, al.plk@... wrote:
>
> Thanks Randy,
>
> The problem is: when you get to the ISNUMERIC() test, you check if "91.50"
> is numeric, which results in a FALSE answer because it is "91,50" (with a
> comma) that is numeric in the french environment.
>
> The problem is that if you try to substitute the dot by a comma in the
> function argument, you get no answer (a blank).
>
> Just like if there were a sort of validity check that rejects outright an
> argument with a comma instead of a dot as a decimal separator.
>
> Is there a way in VBA to modify the system regional settings? (like you
> said, modifying the option in EXCEL doesn't seem to affect the VBA
> environment...)
>
VBA.
On Fri, Aug 8, 2014 at 10:43 AM, al.plk@... wrote:
>
> Thanks Randy,
>
> The problem is: when you get to the ISNUMERIC() test, you check if "91.50"
> is numeric, which results in a FALSE answer because it is "91,50" (with a
> comma) that is numeric in the french environment.
>
> The problem is that if you try to substitute the dot by a comma in the
> function argument, you get no answer (a blank).
>
> Just like if there were a sort of validity check that rejects outright an
> argument with a comma instead of a dot as a decimal separator.
>
> Is there a way in VBA to modify the system regional settings? (like you
> said, modifying the option in EXCEL doesn't seem to affect the VBA
> environment.
>
Fri Aug 8, 2014 11:18 am (PDT) . Posted by:
chrg
I got the VBA line responsible for my problem: in line 54 of the getoptionquotes module
sTickers = sTickers & Replace(oCell.Value, ",", "+") & "+"
If the decimal separator is a comma (like in #@!french%§# !!!), the argument is changed to
"QQQ Aug 2014 91+50 C+" and the function is confused....
In excel, the french argument separator is changed to ";" instead of the usual ",", so that the example you gave would be, in french:
=smfGetOptionQuotes("QQQ Aug 2014 91,50 C";"b")
And that doesn't work with the function...
Not easy to find a universal solution to such a boring problem :)
Thanks anyway,
sTickers = sTickers & Replace(oCell.
If the decimal separator is a comma (like in #@!french%§# !!!), the argument is changed to
"QQQ Aug 2014 91+50 C+" and the function is confused....
In excel, the french argument separator is changed to ";" instead of the usual ","
=smfGetOptionQuotes
And that doesn't work with the function...
Not easy to find a universal solution to such a boring problem :)
Thanks anyway,
Fri Aug 8, 2014 11:28 am (PDT) . Posted by:
chrg
The solution for the french environment is simply to change the comma in line 54 by a semicolon.
Of course, it wouldn't work for the english environment.
Of course, it wouldn't work for the english environment.
Fri Aug 8, 2014 10:21 am (PDT) . Posted by:
tysongayada
hello randy,
i would like to ask if it is possible to extract the entire income statement including the ratios from the link below in a table format?
http://quotes.wsj.com/XOM/financials/annual/income-statement http://quotes.wsj.com/XOM/financials/annual/income-statement
i would like to ask if it is possible to extract the entire income statement including the ratios from the link below in a table format?
http://quotes.wsj.com/XOM/financials/annual/income-statement http://quotes.wsj.com/XOM/financials/annual/income-statement
Fri Aug 8, 2014 10:44 am (PDT) . Posted by:
"Randy Harmelink" rharmelink
How about:
=RCHGetHTMLTable("
http://quotes.wsj.com/XOM/financials/annual/income-statement","5-year
trend",-1,"",2)
On Fri, Aug 8, 2014 at 9:45 AM, tysongayada@yahoo.com [smf_addin] <
smf_addin@yahoogroups.com> wrote:
> i would like to ask if it is possible to extract the entire income
> statement including the ratios from the link below in a table format?
>
> http://quotes.wsj.com/XOM/financials/annual/income-statement
>
=RCHGetHTMLTable("
http://quotes.wsj.com/XOM/financials/annual/income-statement","5-year
trend",-1,"",2)
On Fri, Aug 8, 2014 at 9:45 AM, tysongayada@yahoo.com [smf_addin] <
smf_addin@yahoogroups.com> wrote:
> i would like to ask if it is possible to extract the entire income
> statement including the ratios from the link below in a table format?
>
> http://quotes.wsj.com/XOM/financials/annual/income-statement
>
Fri Aug 8, 2014 11:57 am (PDT) . Posted by:
zbgb952
I am having trouble using this function in Excel...but not for all stock tickers..
IF($D145="","",TRIM(smfGetTagContent("http://investing.money.msn.com/investments/stock-ratings?symbol=" & D145,"div",-2,">Scouter")))
In the formula above, cell D145 just refers to a stock ticker.
When the stock is INTC (for Intel), I get an error message. I am also getting error messages for tickers: NLY, HTGC, SNH, DLR, O, PRK, BMR, FPO, HIW and others.
However, it works for tickers like RY KMP ORI COH NTI PBF and many others
This problem started a few days ago and hasn't gone away
When I go to MSN stock scouters website:
http://money.msn.com/investing/stockscouter-stock-ratings.aspx http://money.msn.com/investing/stockscouter-stock-ratings.aspx
and type intc in the entry box under "
GET A STOCKSCOUTER REPORT" and click the "GO" button, it says "no information available".
However , if I then click my right mouse button and click on 'reload', the website comes up with the data. This only happens for some tickers like intc, but not for others. I have tried this with both the new Firefox (which I now use) and Internet Explorer. I get the same results with both.
I am also using Windows 7.
Anyone else having similar problems.
Anyone , Randy...do you know what is causing this and/or how to fix it? Do you get
the same problem?
thanks.
IF($D145="","",TRIM(smfGetTagContent("http://investing.money.msn.com/investments/stock-ratings?symbol=" & D145,"div",-2,">Scouter")))
In the formula above, cell D145 just refers to a stock ticker.
When the stock is INTC (for Intel), I get an error message. I am also getting error messages for tickers: NLY, HTGC, SNH, DLR, O, PRK, BMR, FPO, HIW and others.
However, it works for tickers like RY KMP ORI COH NTI PBF and many others
This problem started a few days ago and hasn't gone away
When I go to MSN stock scouters website:
http://money.msn.com/investing/stockscouter-stock-ratings.aspx http://money.msn.com/investing/stockscouter-stock-ratings.aspx
and type intc in the entry box under "
GET A STOCKSCOUTER REPORT" and click the "GO" button, it says "no information available"
However , if I then click my right mouse button and click on 'reload&#
I am also using Windows 7.
Anyone else having similar problems.
Anyone , Randy...do you know what is causing this and/or how to fix it? Do you get
the same problem?
thanks.
Fri Aug 8, 2014 4:36 pm (PDT) . Posted by:
"Randy Harmelink" rharmelink
I get the same problem. But I don't have a solution for you.
I think MSN has been screwing around with their web pages again. Most of
the MSN elements for RCHGetElementNumber() come from the "print" page for
the stock. If I use the StockScouter value from that page, I get "NA"
returned.
And, I just noticed yesterday that the "print" page cannot be displayed
from FireFox or Chrome, only Internet Explorer. I used to get able to get
the "print" page in FireFox, so I suspect they are fiddling around with
something.
On Fri, Aug 8, 2014 at 11:57 AM, mb0329@msn.com [smf_addin] <
smf_addin@yahoogroups.com> wrote:
> I am having trouble using this function in Excel...but not for all stock
> tickers..
>
> IF($D145="","",TRIM(smfGetTagContent("
> http://investing.money.msn.com/investments/stock-ratings?symbol=" &
> D145,"div",-2,">Scouter")))
>
> In the formula above, cell D145 just refers to a stock ticker.
>
> When the stock is INTC (for Intel), I get an error message. I am also
> getting error messages for tickers: NLY, HTGC, SNH, DLR, O, PRK, BMR, FPO,
> HIW and others.
>
> However, it works for tickers like RY KMP ORI COH NTI PBF and many others
>
> This problem started a few days ago and hasn't gone away
>
> When I go to MSN stock scouters website:
>
> http://money.msn.com/investing/stockscouter-stock-ratings.aspx
>
> and type intc in the entry box under "
> GET A STOCKSCOUTER REPORT"
>
> and click the "GO" button, it says "no information available".
>
> However , if I then click my right mouse button and click on 'reload', the
> website comes up with the data. This only happens for some tickers like
> intc, but not for others. I have tried this with both the new Firefox
> (which I now use) and Internet Explorer. I get the same results with both.
>
> I am also using Windows 7.
>
> Anyone else having similar problems.
>
> Anyone , Randy...do you know what is causing this and/or how to fix it? Do
> you get
>
> the same problem?
>
I think MSN has been screwing around with their web pages again. Most of
the MSN elements for RCHGetElementNumber() come from the "print" page for
the stock. If I use the StockScouter value from that page, I get "NA"
returned.
And, I just noticed yesterday that the "print" page cannot be displayed
from FireFox or Chrome, only Internet Explorer. I used to get able to get
the "print" page in FireFox, so I suspect they are fiddling around with
something.
On Fri, Aug 8, 2014 at 11:57 AM, mb0329@msn.com [smf_addin] <
smf_addin@yahoogroups.com> wrote:
> I am having trouble using this function in Excel...but not for all stock
> tickers..
>
> IF($D145="","",TRIM(smfGetTagContent("
> http://investing.money.msn.com/investments/stock-ratings?symbol=" &
> D145,"div",-2,">Scouter")))
>
> In the formula above, cell D145 just refers to a stock ticker.
>
> When the stock is INTC (for Intel), I get an error message. I am also
> getting error messages for tickers: NLY, HTGC, SNH, DLR, O, PRK, BMR, FPO,
> HIW and others.
>
> However, it works for tickers like RY KMP ORI COH NTI PBF and many others
>
> This problem started a few days ago and hasn't gone away
>
> When I go to MSN stock scouters website:
>
> http://money.msn.com/investing/stockscouter-stock-ratings.aspx
>
> and type intc in the entry box under "
> GET A STOCKSCOUTER REPORT"
>
> and click the "GO" button, it says "no information available"
>
> However , if I then click my right mouse button and click on 'reload&#
> website comes up with the data. This only happens for some tickers like
> intc, but not for others. I have tried this with both the new Firefox
> (which I now use) and Internet Explorer. I get the same results with both.
>
> I am also using Windows 7.
>
> Anyone else having similar problems.
>
> Anyone , Randy...do you know what is causing this and/or how to fix it? Do
> you get
>
> the same problem?
>
For the Add-in, Documentation, Templates, Tips and FAQs, visit http://ogres-crypt.com/SMF
Tidak ada komentar:
Posting Komentar