15 New Messages
Digest #2850
Messages
Sun Nov 10, 2013 12:00 pm (PST) . Posted by:
"Randy Harmelink" rharmelink
This worked fine here:
=RCHGetElementNumber("MMM";,13863)
What do you have for:
=smfGetAParms(13863)
On Sun, Nov 10, 2013 at 12:54 PM, <pc_babe@msn.com> wrote:
> Is any one else having difficulty pulling this element?
>
=RCHGetElementNumbe
What do you have for:
=smfGetAParms(
On Sun, Nov 10, 2013 at 12:54 PM, <pc_babe@msn.
> Is any one else having difficulty pulling this element?
>
Sun Nov 10, 2013 12:07 pm (PST) . Posted by:
"Randy Harmelink" rharmelink
Hmmm. Looks like everything should be working then. Your prefix isn't the
issue.
Did you apply the IE fix mentioned in the LINKS area of the group?
Otherwise, what do you get with:
=RCHGetTableCell("http://www.advfn.com/exchanges/NYSE/MMM/stock-price
",1,">Name","<tr")
=RCHGetTableCell("http://www.advfn.com/exchanges/NYSE/MMM/stock-price
",3,">Name","<tr")
=RCHGetTableCell("http://www.advfn.com/exchanges/NYSE/MMM/financials",1,"PE
Ratio")
=RCHGetTableCell("
http://www.advfn.com/exchanges/NYSE/MMM/financials?btn=quarterly_reports",
1,">Quarter End Date")
On Sun, Nov 10, 2013 at 12:57 PM, <johkouf@hotmail.com> wrote:
> http://www.advfn.com/exchanges/NYSE/MMM/stock-price
>
issue.
Did you apply the IE fix mentioned in the LINKS area of the group?
Otherwise, what do you get with:
=RCHGetTableCell(
",1,"
=RCHGetTableCell(
",3,"
=RCHGetTableCell(
Ratio")
=RCHGetTableCell(
http://www.advfn.
1,">
On Sun, Nov 10, 2013 at 12:57 PM, <johkouf@hotmail.
> http://www.advfn.
>
Sun Nov 10, 2013 12:21 pm (PST) . Posted by:
af3512b8ef4166b5c33401271c05da3c
---In smf_addin@yahoogrou
Hmmm. Looks like everything should be working then. Your prefix isn't the issue.
Did you apply the IE fix mentioned in the LINKS area of the group?
Otherwise, what do you get with:
=RCHGetTableCell(
=RCHGetTableCell(
=RCHGetTableCell(
=RCHGetTableCell(
1,">
On Sun, Nov 10, 2013 at 12:57 PM, <johkouf@
http://www.advfn.
Sun Nov 10, 2013 12:22 pm (PST) . Posted by:
af3512b8ef4166b5c33401271c05da3c
I get
3M Company http://www.advfn.com/exchanges/NYSE/MMM/stock-price NYSE http://www.advfn.com/exchanges/NYSE/MMM/stock-price 17.6 http://www.advfn.com/exchanges/NYSE/MMM/financials 2012/06
Should I apply a fix ?
---In smf_addin@yahoogroups.com, <rharmelink@...> wrote:
Hmmm. Looks like everything should be working then. Your prefix isn't the issue.
Did you apply the IE fix mentioned in the LINKS area of the group?
Otherwise, what do you get with:
=RCHGetTableCell("http://www.advfn.com/exchanges/NYSE/MMM/stock-price http://www.advfn.com/exchanges/NYSE/MMM/stock-price",1,">Name","<tr")
=RCHGetTableCell("http://www.advfn.com/exchanges/NYSE/MMM/stock-price http://www.advfn.com/exchanges/NYSE/MMM/stock-price",3,">Name","<tr")
=RCHGetTableCell("http://www.advfn.com/exchanges/NYSE/MMM/financials http://www.advfn.com/exchanges/NYSE/MMM/financials",1,"PE Ratio")
=RCHGetTableCell("http://www.advfn.com/exchanges/NYSE/MMM/financials?btn=quarterly_reports http://www.advfn.com/exchanges/NYSE/MMM/financials?btn=quarterly_reports",
1,">Quarter End Date")
On Sun, Nov 10, 2013 at 12:57 PM, <johkouf@... mailto:johkouf@...> wrote:
http://www.advfn.com/exchanges/NYSE/MMM/stock-price http://www.advfn.com/exchanges/NYSE/MMM/stock-price
3M Company http://www.advfn.
Should I apply a fix ?
---In smf_addin@yahoogrou
Hmmm. Looks like everything should be working then. Your prefix isn't the issue.
Did you apply the IE fix mentioned in the LINKS area of the group?
Otherwise, what do you get with:
=RCHGetTableCell(
=RCHGetTableCell(
=RCHGetTableCell(
=RCHGetTableCell(
1,">
On Sun, Nov 10, 2013 at 12:57 PM, <johkouf@
http://www.advfn.
Sun Nov 10, 2013 12:47 pm (PST) . Posted by:
"Randy Harmelink" rharmelink
Looks like everything should be working. I don't know what to tell you at
this point.
This is the function invocation the element definition should be doing:
=smfGetAdvFNElement("MMM","Q",1,">INCOME STATEMENT",">EBITDA")
...which would do this function invocation:
=RCHGetTableCell("
http://www.advfn.com/exchanges/NYSE/MMM/financials?&mode=quarterly_reports&btn=istart_date
",
5, ">Income Statement",">EBITDA")
Do those both return "Error" for you as well?
What country are you in?
On Sun, Nov 10, 2013 at 1:22 PM, <johkouf@hotmail.com> wrote:
>
> I get
>
> 3M Company <http://www.advfn.com/exchanges/NYSE/MMM/stock-price> NYSE<http://www.advfn.com/exchanges/NYSE/MMM/stock-price>
> 17.6 <http://www.advfn.com/exchanges/NYSE/MMM/financials> 2012/06
>
> Should I apply a fix ?
>
this point.
This is the function invocation the element definition should be doing:
=smfGetAdvFNElement
...which would do this function invocation:
=RCHGetTableCell(
http://www.advfn.
",
5, ">Income Statement"
Do those both return "Error" for you as well?
What country are you in?
On Sun, Nov 10, 2013 at 1:22 PM, <johkouf@hotmail.
>
> I get
>
> 3M Company <http://www.advfn.
> 17.6 <http://www.advfn.
>
> Should I apply a fix ?
>
Sun Nov 10, 2013 1:00 pm (PST) . Posted by:
af3512b8ef4166b5c33401271c05da3c
I get error for the first and 1702 for the second
I am in Greece
---In smf_addin@yahoogroups.com, <rharmelink@...> wrote:
Looks like everything should be working. I don't know what to tell you at this point.
This is the function invocation the element definition should be doing:
=smfGetAdvFNElement("MMM","Q",1,">INCOME STATEMENT",">EBITDA")
...which would do this function invocation:
=RCHGetTableCell("http://www.advfn.com/exchanges/NYSE/MMM/financials?&mode=quarterly_reports&btn=istart_date http://www.advfn.com/exchanges/NYSE/MMM/financials?&mode=quarterly_reports&btn=istart_date",
5, ">Income Statement",">EBITDA")
Do those both return "Error" for you as well?
What country are you in?
On Sun, Nov 10, 2013 at 1:22 PM, <johkouf@... mailto:johkouf@...> wrote:
I get
3M Company http://www.advfn.com/exchanges/NYSE/MMM/stock-price NYSE http://www.advfn.com/exchanges/NYSE/MMM/stock-price 17.6 http://www.advfn.com/exchanges/NYSE/MMM/financials 2012/06 Should I apply a fix ?
I am in Greece
---In smf_addin@yahoogrou
Looks like everything should be working. I don't know what to tell you at this point.
This is the function invocation the element definition should be doing:
=smfGetAdvFNElement
...which would do this function invocation:
=RCHGetTableCell(
5, ">Income Statement"
Do those both return "Error" for you as well?
What country are you in?
On Sun, Nov 10, 2013 at 1:22 PM, <johkouf@
I get
3M Company http://www.advfn.
Sun Nov 10, 2013 1:12 pm (PST) . Posted by:
"Randy Harmelink" rharmelink
Wow. That makes no sense to me, since the first should be invoking the
second.
How about...what do you get for:
=smfstrExtr(RCHGetWebData("
http://www.advfn.com/p.php?pid=financials&mode=quarterly_reports&symbol=MMM",
"/exchanges/", 50), "s/", "/")
=smfstrExtr(RCHGetWebData("
http://www.advfn.com/p.php?pid=financials&mode=quarterly_reports&symbol=MMM",
"canonical",150),"=""","""")
=RCHGetWebData("
http://www.advfn.com/p.php?pid=financials&mode=quarterly_reports&symbol=MMM",
"canonical",150)
On Sun, Nov 10, 2013 at 2:00 PM, <johkouf@hotmail.com> wrote:
> I get error for the first and 1702 for the second
>
second.
How about...what do you get for:
=smfstrExtr(
http://www.advfn.
"/exchanges/
=smfstrExtr(
http://www.advfn.
"canonical&quo
=RCHGetWebData(
http://www.advfn.
"canonical&quo
On Sun, Nov 10, 2013 at 2:00 PM, <johkouf@hotmail.
> I get error for the first and 1702 for the second
>
Sun Nov 10, 2013 1:16 pm (PST) . Posted by:
af3512b8ef4166b5c33401271c05da3c
For the first two I get blank cells and for the third Error
Thanks for the effort Randy !!
---In smf_addin@yahoogroups.com, <rharmelink@...> wrote:
Wow. That makes no sense to me, since the first should be invoking the second.
How about...what do you get for:
=smfstrExtr(RCHGetWebData("http://www.advfn.com/p.php?pid=financials&mode=quarterly_reports&symbol=MMM http://www.advfn.com/p.php?pid=financials&mode=quarterly_reports&symbol=MMM", "/exchanges/", 50), "s/", "/")
=smfstrExtr(RCHGetWebData("http://www.advfn.com/p.php?pid=financials&mode=quarterly_reports&symbol=MMM http://www.advfn.com/p.php?pid=financials&mode=quarterly_reports&symbol=MMM", "canonical",150),"=""","""")
=RCHGetWebData("http://www.advfn.com/p.php?pid=financials&mode=quarterly_reports&symbol=MMM http://www.advfn.com/p.php?pid=financials&mode=quarterly_reports&symbol=MMM", "canonical",150)
On Sun, Nov 10, 2013 at 2:00 PM, <johkouf@... mailto:johkouf@...> wrote:
I get error for the first and 1702 for the second
Thanks for the effort Randy !!
---In smf_addin@yahoogrou
Wow. That makes no sense to me, since the first should be invoking the second.
How about...what do you get for:
=smfstrExtr(
=smfstrExtr(
=RCHGetWebData(
On Sun, Nov 10, 2013 at 2:00 PM, <johkouf@
I get error for the first and 1702 for the second
Sun Nov 10, 2013 1:21 pm (PST) . Posted by:
"Randy Harmelink" rharmelink
You're sure you're not being redirected to a different web page for the URL
below?
http://www.advfn.com/p.php?pid=financials&mode=quarterly_reports&symbol=MMM
Otherwise, the source code of your delivered web page is different than
mine.
Can you attach a copy of the source code of the web page? Something is
funky about this.
On Sun, Nov 10, 2013 at 2:16 PM, <johkouf@hotmail.com> wrote:
> For the first two I get blank cells and for the third Error
>
> Thanks for the effort Randy !!
>
below?
http://www.advfn.
Otherwise, the source code of your delivered web page is different than
mine.
Can you attach a copy of the source code of the web page? Something is
funky about this.
On Sun, Nov 10, 2013 at 2:16 PM, <johkouf@hotmail.
> For the first two I get blank cells and for the third Error
>
> Thanks for the effort Randy !!
>
Sun Nov 10, 2013 1:24 pm (PST) . Posted by:
af3512b8ef4166b5c33401271c05da3c
oooo wait for this i got redirected to http://uk.advfn.com/p.php?pid=financials&mode=quarterly_reports&symbol=MMM
I cant understand why ?? in the last Url you send me I didnt get redirected !!!
So I just follow the instructions described on the forum to fix this ?
---In smf_addin@yahoogroups.com, <rharmelink@...> wrote:
You're sure you're not being redirected to a different web page for the URL below?
http://www.advfn.com/p.php?pid=financials&mode=quarterly_reports&symbol=MMM http://www.advfn.com/p.php?pid=financials&mode=quarterly_reports&symbol=MMM
Otherwise, the source code of your delivered web page is different than mine.
Can you attach a copy of the source code of the web page? Something is funky about this.
On Sun, Nov 10, 2013 at 2:16 PM, <johkouf@... mailto:johkouf@...> wrote:
For the first two I get blank cells and for the third Error
Thanks for the effort Randy !!
I cant understand why ?? in the last Url you send me I didnt get redirected !!!
So I just follow the instructions described on the forum to fix this ?
---In smf_addin@yahoogrou
You're sure you're not being redirected to a different web page for the URL below?
http://www.advfn.
Otherwise, the source code of your delivered web page is different than mine.
Can you attach a copy of the source code of the web page? Something is funky about this.
On Sun, Nov 10, 2013 at 2:16 PM, <johkouf@
For the first two I get blank cells and for the third Error
Thanks for the effort Randy !!
Sun Nov 10, 2013 1:30 pm (PST) . Posted by:
"Randy Harmelink" rharmelink
I'm hoping all you need to do is create the smf-AdvFN-prefix.txt file in
the folder where the add-in exists, and put the two characters "uk" in
there. You should exit EXCEL before doing so.
However, after those last few functions returns blanks, I have my doubts
whether this will fix the problem.
Can you give me a copy of the source code for that web page:
http://uk.advfn.com/p.php?pid=financials&mode=quarterly_reports&symbol=MMM
I may have to find a different way to extract "exchange"; from the web page.
On Sun, Nov 10, 2013 at 2:24 PM, <johkouf@hotmail.com> wrote:
> oooo wait for this i got redirected to
> http://uk.advfn.com/p.php?pid=financials&mode=quarterly_reports&symbol=MMM
>
> I cant understand why ?? in the last Url you send me I didnt get
> redirected !!!
>
> So I just follow the instructions described on the forum to fix this ?
>
the folder where the add-in exists, and put the two characters "uk" in
there. You should exit EXCEL before doing so.
However, after those last few functions returns blanks, I have my doubts
whether this will fix the problem.
Can you give me a copy of the source code for that web page:
http://uk.advfn.
I may have to find a different way to extract "exchange"
On Sun, Nov 10, 2013 at 2:24 PM, <johkouf@hotmail.
> oooo wait for this i got redirected to
> http://uk.advfn.
>
> I cant understand why ?? in the last Url you send me I didnt get
> redirected !!!
>
> So I just follow the instructions described on the forum to fix this ?
>
Sun Nov 10, 2013 1:38 pm (PST) . Posted by:
af3512b8ef4166b5c33401271c05da3c
Ok I just uploaded on uploads by forum members
---In smf_addin@yahoogroups.com, <rharmelink@...> wrote:
I'm hoping all you need to do is create the smf-AdvFN-prefix.txt file in the folder where the add-in exists, and put the two characters "uk" in there. You should exit EXCEL before doing so.
However, after those last few functions returns blanks, I have my doubts whether this will fix the problem.
Can you give me a copy of the source code for that web page:
http://uk.advfn.com/p.php?pid=financials&mode=quarterly_reports&symbol=MMM http://uk.advfn.com/p.php?pid=financials&mode=quarterly_reports&symbol=MMM
I may have to find a different way to extract "exchange"; from the web page.
On Sun, Nov 10, 2013 at 2:24 PM, <johkouf@... mailto:johkouf@...> wrote:
oooo wait for this i got redirected to http://uk.advfn.com/p.php?pid=financials&mode=quarterly_reports&symbol=MMM http://uk.advfn.com/p.php?pid=financials&mode=quarterly_reports&symbol=MMM
I cant understand why ?? in the last Url you send me I didnt get redirected !!!
So I just follow the instructions described on the forum to fix this ?
---In smf_addin@yahoogrou
I'm hoping all you need to do is create the smf-AdvFN-prefix.
However, after those last few functions returns blanks, I have my doubts whether this will fix the problem.
Can you give me a copy of the source code for that web page:
http://uk.advfn.
I may have to find a different way to extract "exchange"
On Sun, Nov 10, 2013 at 2:24 PM, <johkouf@
oooo wait for this i got redirected to http://uk.advfn.
I cant understand why ?? in the last Url you send me I didnt get redirected !!!
So I just follow the instructions described on the forum to fix this ?
Sun Nov 10, 2013 1:46 pm (PST) . Posted by:
"Randy Harmelink" rharmelink
Based on what I see in the source code, I'm hoping that placing the 2-byte
"uk" into the smf-AdvFN-prefix.txt file will work.
If not, be sure to try the IE fix from the LINKS area of the group.
On Sun, Nov 10, 2013 at 2:38 PM, <johkouf@hotmail.com> wrote:
>
> Ok I just uploaded on uploads by forum members
>
"uk" into the smf-AdvFN-prefix.
If not, be sure to try the IE fix from the LINKS area of the group.
On Sun, Nov 10, 2013 at 2:38 PM, <johkouf@hotmail.
>
> Ok I just uploaded on uploads by forum members
>
Sun Nov 10, 2013 1:51 pm (PST) . Posted by:
af3512b8ef4166b5c33401271c05da3c
Randy thanks for the help and sorry for the trouble , I just applied the fix and works fine !!!
---In smf_addin@yahoogroups.com, <rharmelink@...> wrote:
Based on what I see in the source code, I'm hoping that placing the 2-byte "uk" into the smf-AdvFN-prefix.txt file will work.
If not, be sure to try the IE fix from the LINKS area of the group.
On Sun, Nov 10, 2013 at 2:38 PM, <johkouf@... mailto:johkouf@...> wrote:
Ok I just uploaded on uploads by forum members
---In smf_addin@yahoogrou
Based on what I see in the source code, I'm hoping that placing the 2-byte "uk" into the smf-AdvFN-prefix.
If not, be sure to try the IE fix from the LINKS area of the group.
On Sun, Nov 10, 2013 at 2:38 PM, <johkouf@
Ok I just uploaded on uploads by forum members
Sun Nov 10, 2013 3:17 pm (PST) . Posted by:
ztripp2000
Hello everyone, sorry if this has been asked before.
I am currently using RCHGetTableCell to retrieve sector and industry information for a list of stocks. I have to manually enter the stock on each line.
For example:
=RCHGetTableCell("http://finance.yahoo.com/q/pr?s=MCHP+Profile",1,"Sector:")
Is there a way to automate this?
For examples, if my stocks are in A2:A11. B1 is the header for SECTOR and C1 is the header for INDUSTRY.
Would like to fill B2:C11.
I am currently using RCHGetTableCell to retrieve sector and industry information for a list of stocks. I have to manually enter the stock on each line.
For example:
=RCHGetTableCell(
Is there a way to automate this?
For examples, if my stocks are in A2:A11. B1 is the header for SECTOR and C1 is the header for INDUSTRY.
Would like to fill B2:C11.
Tidak ada komentar:
Posting Komentar