12 New Messages
Digest #2413
3b
Re: SMF-Template-RCHGetYahooQuotes.xls 163 KB rharmelink Aug 14, 200 by "Randy Harmelink" rharmelink
Messages
Mon Nov 26, 2012 5:10 am (PST) . Posted by:
"jcarlosd" jcarlosd
I appreciate your answers, Randy. But it seems that I always get stacked with trivial questions: I was able to interact with the InternetExplorer object within VBA. So far, no problem.
But later, when I use smfStrExtr, it seems that inside Excel the cookie is not set. How can I setup the cookie within Excel VBA?
J. Carlos
--- In smf_addin@yahoogroups.com , Randy Harmelink <rharmelink@...> wrote:
>
> You should be able to do that with VBA by interacting with the
> InternetExplorer object. Do they allow changing? Otherwise, depending on
> the expiration date of the cookie, the "login" may only need to be done
> once.
>
> On Sat, Nov 24, 2012 at 11:37 AM, jcarlosd <jcdelrio@...> wrote:
>
> >
> > Is there any way to setup that security cookie you mentioned when I enter
> > with my VBA macro? I do not want to have to create manually a web query and
> > select manually the country. Or is there any way to change it to other
> > condition, like change of domicile country?
> >
>
But later, when I use smfStrExtr, it seems that inside Excel the cookie is not set. How can I setup the cookie within Excel VBA?
J. Carlos
--- In smf_addin@yahoogrou
>
> You should be able to do that with VBA by interacting with the
> InternetExplorer object. Do they allow changing? Otherwise, depending on
> the expiration date of the cookie, the "login" may only need to be done
> once.
>
> On Sat, Nov 24, 2012 at 11:37 AM, jcarlosd <jcdelrio@..
>
> >
> > Is there any way to setup that security cookie you mentioned when I enter
> > with my VBA macro? I do not want to have to create manually a web query and
> > select manually the country. Or is there any way to change it to other
> > condition, like change of domicile country?
> >
>
Mon Nov 26, 2012 5:37 am (PST) . Posted by:
"Randy Harmelink" rharmelink
Sorry, but that' not something I want to get into. Although it would need
to be something like what is here:
http://www.wiredbox.net/forum/Thread399198_Using_Script_to_download_from_secure_site.aspx
On Mon, Nov 26, 2012 at 6:10 AM, jcarlosd <jcdelrio@procesando.com > wrote:
>
> But later, when I use smfStrExtr, it seems that inside Excel the cookie is
> not set. How can I setup the cookie within Excel VBA?
>
to be something like what is here:
http://www.wiredbox
On Mon, Nov 26, 2012 at 6:10 AM, jcarlosd <jcdelrio@procesando
>
> But later, when I use smfStrExtr, it seems that inside Excel the cookie is
> not set. How can I setup the cookie within Excel VBA?
>
Mon Nov 26, 2012 6:20 am (PST) . Posted by:
"lezm001" lezm001
The SMF addin was working fine for me until I upgraded from IE8 to IE9. I recall having to change something in the internet explorer setting before so the file opens without errors. Does anyone know what IE settings need to change?
Mon Nov 26, 2012 7:14 am (PST) . Posted by:
"Randy Harmelink" rharmelink
Check the AdvFN item in the LINKS area of the group. Also, item 9.4.2.
On Mon, Nov 26, 2012 at 7:20 AM, lezm001 <dlezman@steelcase.com > wrote:
> The SMF addin was working fine for me until I upgraded from IE8 to IE9. I
> recall having to change something in the internet explorer setting before
> so the file opens without errors. Does anyone know what IE settings need
> to change?
>
On Mon, Nov 26, 2012 at 7:20 AM, lezm001 <dlezman@steelcase.
> The SMF addin was working fine for me until I upgraded from IE8 to IE9. I
> recall having to change something in the internet explorer setting before
> so the file opens without errors. Does anyone know what IE settings need
> to change?
>
Mon Nov 26, 2012 6:52 am (PST) . Posted by:
"Sam Williams" iamruf
*I followed the 9.4.2 LINKS instruction and per your comment, I did have to
make the change indicated, but the file still will not update with f9.*
*
*
*I also tried the formulas you gave to another person, in a new sheet:*
=RCHGetElementNumber("Version")
=smfGetAParms(3)
*First one produced:*
Stock Market Functions add-in, Version 2.1.2012.02.02 (C:\Program Files
(x86)\SMF Add-in; 2)
*Second one doesn't show anything (just returns a blank cell).*
*Please advise.*
On Sun, Nov 25, 2012 at 9:52 PM, Randy Harmelink <rharmelink@gmail.com >wrote:
> **
>
>
> I just tried the file from the group, and it updates with F9 just fine for
> me.
>
> Do you maybe have your Internet Options set to cache the Temporary
> Internet Files? See item 9.4.2 in the LINKS area of the group.
>
>
> On Sun, Nov 25, 2012 at 7:44 PM, iamruf <iam.samw@gmail.com > wrote:
>
>> SMF-Template-RCHGetYahooQuotes.xls 163 KB rharmelink Aug 14, 2007
>> A template with an example of using the RCHGetYahooQuotes() function.
>> I have downloaded this template to Excel 2010 but it will not run with
>> either F9 or Shift F9.
>> Please advise if there is something else I need to do.
>>
>
>
>
make the change indicated, but the file still will not update with f9.*
*
*
*I also tried the formulas you gave to another person, in a new sheet:*
=RCHGetElementNumbe
=smfGetAParms(
*First one produced:*
Stock Market Functions add-in, Version 2.1.2012.02.
(x86)\SMF Add-in; 2)
*Second one doesn't show anything (just returns a blank cell).*
*Please advise.*
On Sun, Nov 25, 2012 at 9:52 PM, Randy Harmelink <rharmelink@gmail.
> **
>
>
> I just tried the file from the group, and it updates with F9 just fine for
> me.
>
> Do you maybe have your Internet Options set to cache the Temporary
> Internet Files? See item 9.4.2 in the LINKS area of the group.
>
>
> On Sun, Nov 25, 2012 at 7:44 PM, iamruf <iam.samw@gmail.
>
>> SMF-Template-
>> A template with an example of using the RCHGetYahooQuotes(
>> I have downloaded this template to Excel 2010 but it will not run with
>> either F9 or Shift F9.
>> Please advise if there is something else I need to do.
>>
>
>
>
Mon Nov 26, 2012 7:20 am (PST) . Posted by:
"Randy Harmelink" rharmelink
The add-in may have difficulties if you don't have regional settings set to
U.S.. That determines how VBA does numeric conversions.
What does your formula in cell C4 contain? Do the values in cells B203 and
D34 change when you hit F9?
On Mon, Nov 26, 2012 at 7:52 AM, Sam Williams <iam.samw@gmail.com > wrote:
>
> *I followed the 9.4.2 LINKS instruction and per your comment, I did have
> to make the change indicated, but the file still will not update with f9.*
> *
> *
> *I also tried the formulas you gave to another person, in a new sheet:*
> =RCHGetElementNumber("Version")
> =smfGetAParms(3)
> *First one produced:*
> Stock Market Functions add-in, Version 2.1.2012.02.02 (C:\Program Files
> (x86)\SMF Add-in; 2)
> *Second one doesn't show anything (just returns a blank cell).*
> *Please advise.*
>
U.S.. That determines how VBA does numeric conversions.
What does your formula in cell C4 contain? Do the values in cells B203 and
D34 change when you hit F9?
On Mon, Nov 26, 2012 at 7:52 AM, Sam Williams <iam.samw@gmail.
>
> *I followed the 9.4.2 LINKS instruction and per your comment, I did have
> to make the change indicated, but the file still will not update with f9.*
> *
> *
> *I also tried the formulas you gave to another person, in a new sheet:*
> =RCHGetElementNumbe
> =smfGetAParms(
> *First one produced:*
> Stock Market Functions add-in, Version 2.1.2012.02.
> (x86)\SMF Add-in; 2)
> *Second one doesn't show anything (just returns a blank cell).*
> *Please advise.*
>
Mon Nov 26, 2012 10:16 am (PST) . Posted by:
"Randy H" rharmelink
That's why you're not working -- you need to fix your unresolved links
(that's why you see the path before the function name). See the location
errors item in the LINKS area of the group.
On Mon, Nov 26, 2012 at 10:40 AM, Sam Williams <iam.samw@...
<mailto:iam.samw@gmail.com > > wrote:
Cell C4 contains: {'='C:\Program Files\SMF
Add-In\RCH_Stock_Market_Functions.xla'!RCHGetYahooQuotes(B4:B203,C2:V2)}\
The value in B203 changes to a random number whenever I hit F9.B34 does
not have a Ticker and so D34 returns #NAME? (the same as is returned for
all cells in worksheet).Variable worksheet cells flicker with F9 but
still return #NAME?.OOPS! I changed my regional settings from Canada to
US and now the value in B203 does NOT change when I hit F9!
(that's why you see the path before the function name). See the location
errors item in the LINKS area of the group.
On Mon, Nov 26, 2012 at 10:40 AM, Sam Williams <iam.samw@..
<mailto:iam.samw@gmail.
Cell C4 contains: {'='C:\Program Files\SMF
Add-In\RCH_Stock_
The value in B203 changes to a random number whenever I hit F9.B34 does
not have a Ticker and so D34 returns #NAME? (the same as is returned for
all cells in worksheet).Variable worksheet cells flicker with F9 but
still return #NAME?.OOPS! I changed my regional settings from Canada to
US and now the value in B203 does NOT change when I hit F9!
Mon Nov 26, 2012 6:02 pm (PST) . Posted by:
"mic_peg" mic_peg
Hi,
I tried to retrieve the whole table on sectoral perfomance from the formula as below but not able to do it. Thanks for your help and explanation for -1 and 1.
=RCHGetHTMLTable("http://investing.businessweek.com/research/sectorandindustry/overview/sectorlanding.asp ",
"Dividend Yield",-1,"",1)
"Performance Price perEarnings(TTM) Price to Sales (TTM) Dividend Yield .......... "
I tried to retrieve the whole table on sectoral perfomance from the formula as below but not able to do it. Thanks for your help and explanation for -1 and 1.
=RCHGetHTMLTable(
"Dividend Yield",-1,""
"Performance Price perEarnings(
Mon Nov 26, 2012 7:26 pm (PST) . Posted by:
"Randy Harmelink" rharmelink
Try:
=RCHGetHTMLTable("
http://investing.businessweek.com/research/sectorandindustry/overview/sectorlanding.asp
","sectorTable",-1,"",1)
...which says to search for "sectorTable" within the source code of the web
page (the "id" of the table), then find the first table tag BEFORE that
string (i.e. -1), and the first ending table tag AFTER that string (i.e. 1).
"Dividend Yield didn't work because they have it coded to break and wrap in
the column, so there was no space in between the words. The other string I
considered for the search was "(TTM)".
On Mon, Nov 26, 2012 at 7:02 PM, mic_peg <mic_peg@yahoo.com > wrote:
>
> I tried to retrieve the whole table on sectoral perfomance from the
> formula as below but not able to do it. Thanks for your help and
> explanation for -1 and 1.
>
> =RCHGetHTMLTable("
> http://investing.businessweek.com/research/sectorandindustry/overview/sectorlanding.asp
> ",
> "Dividend Yield",-1,"",1)
>
> "Performance Price perEarnings(TTM) Price to Sales (TTM) Dividend Yield
> .......... "
>
=RCHGetHTMLTable(
http://investing.
","sectorTable"
...which says to search for "sectorTable" within the source code of the web
page (the "id" of the table), then find the first table tag BEFORE that
string (i.e. -1), and the first ending table tag AFTER that string (i.e. 1).
"Dividend Yield didn't work because they have it coded to break and wrap in
the column, so there was no space in between the words. The other string I
considered for the search was "(TTM)".
On Mon, Nov 26, 2012 at 7:02 PM, mic_peg <mic_peg@yahoo.
>
> I tried to retrieve the whole table on sectoral perfomance from the
> formula as below but not able to do it. Thanks for your help and
> explanation for -1 and 1.
>
> =RCHGetHTMLTable(
> http://investing.
> ",
> "Dividend Yield",-1,""
>
> "Performance Price perEarnings(
> .......... "
>
Mon Nov 26, 2012 7:38 pm (PST) . Posted by:
"mic_peg" mic_peg
tks ! it works well now
--- In smf_addin@yahoogroups.com , Randy Harmelink <rharmelink@...> wrote:
>
> Try:
>
> =RCHGetHTMLTable("
> http://investing.businessweek.com/research/sectorandindustry/overview/sectorlanding.asp
> ","sectorTable",-1,"",1)
>
> ...which says to search for "sectorTable" within the source code of the web
> page (the "id" of the table), then find the first table tag BEFORE that
> string (i.e. -1), and the first ending table tag AFTER that string (i.e. 1).
>
> "Dividend Yield didn't work because they have it coded to break and wrap in
> the column, so there was no space in between the words. The other string I
> considered for the search was "(TTM)".
>
> On Mon, Nov 26, 2012 at 7:02 PM, mic_peg <mic_peg@...> wrote:
>
> >
> > I tried to retrieve the whole table on sectoral perfomance from the
> > formula as below but not able to do it. Thanks for your help and
> > explanation for -1 and 1.
> >
> > =RCHGetHTMLTable("
> > http://investing.businessweek.com/research/sectorandindustry/overview/sectorlanding.asp
> > ",
> > "Dividend Yield",-1,"",1)
> >
> > "Performance Price perEarnings(TTM) Price to Sales (TTM) Dividend Yield
> > .......... "
> >
>
--- In smf_addin@yahoogrou
>
> Try:
>
> =RCHGetHTMLTable(
> http://investing.
> ","sectorTable"
>
> ...which says to search for "sectorTable" within the source code of the web
> page (the "id" of the table), then find the first table tag BEFORE that
> string (i.e. -1), and the first ending table tag AFTER that string (i.e. 1).
>
> "Dividend Yield didn't work because they have it coded to break and wrap in
> the column, so there was no space in between the words. The other string I
> considered for the search was "(TTM)".
>
> On Mon, Nov 26, 2012 at 7:02 PM, mic_peg <mic_peg@...
>
> >
> > I tried to retrieve the whole table on sectoral perfomance from the
> > formula as below but not able to do it. Thanks for your help and
> > explanation for -1 and 1.
> >
> > =RCHGetHTMLTable(
> > http://investing.
> > ",
> > "Dividend Yield",-1,""
> >
> > "Performance Price perEarnings(
> > .......... "
> >
>
Mon Nov 26, 2012 6:23 pm (PST) . Posted by:
"José Azevedo" jma_resende
Hello!
- I have a error in this command:
B4=CALL
=RCHGetTableCell("http://www.finviz.com/quote.ashx?t= "&B4;1;"P/S")
What are wrong?
- In this page:
http://money.cnn.com/quote/forecast/forecast.html?symb=CALL
In below of the page, in Sales, there are "*Growth *annually 35.62%"
Is it possible get the value "35.62"?
Many thanks
Jose
- I have a error in this command:
B4=CALL
=RCHGetTableCell(
What are wrong?
- In this page:
http://money.
In below of the page, in Sales, there are "*Growth *annually 35.62%"
Is it possible get the value "35.62"?
Many thanks
Jose
Mon Nov 26, 2012 7:34 pm (PST) . Posted by:
"Randy Harmelink" rharmelink
Try:
=RCHGetTableCell("http://www.finviz.com/quote.ashx?t=CALL ",1,">P/S")
The reason "P/S" didn't work is because the first occurrence of those three
characters was in a link on the web page that contained: "hel*p/s*creener".
For the other item, try:
=0+smfGetTagContent("
http://money.cnn.com/quote/forecast/forecast.html?symb=CALL
","span",1,">Annually",">Annually")
On Mon, Nov 26, 2012 at 7:23 PM, José Azevedo <jmazevedo@gmail.com > wrote:
>
> - I have a error in this command:
> B4=CALL
> =RCHGetTableCell("http://www.finviz.com/quote.ashx?t= "&B4;1;"P/S")
> What are wrong?
>
> - In this page:
> http://money.cnn.com/quote/forecast/forecast.html?symb=CALL
> In below of the page, in Sales, there are "*Growth *annually 35.62%"
> Is it possible get the value "35.62"?
>
=RCHGetTableCell(
The reason "P/S" didn't work is because the first occurrence of those three
characters was in a link on the web page that contained: "hel*p/s*creener"
For the other item, try:
=0+smfGetTagContent
http://money.
","span",1,"
On Mon, Nov 26, 2012 at 7:23 PM, José Azevedo <jmazevedo@gmail.
>
> - I have a error in this command:
> B4=CALL
> =RCHGetTableCell(
> What are wrong?
>
> - In this page:
> http://money.
> In below of the page, in Sales, there are "*Growth *annually 35.62%"
> Is it possible get the value "35.62"?
>
Tidak ada komentar:
Posting Komentar