15 New Messages
Digest #2803
Messages
Thu Oct 10, 2013 7:43 am (PDT) . Posted by:
stephen.ronson@ymail.com
I'm sorry. I'm still having trouble with this. In my excel spread sheet I have the letters IVE in cell A3
but none of these work:
=RCHGetTableCell("http://finance.yahoo.com/q/pr?s= http://finance.yahoo.com/q/pr?s="&"A3",1,"Annual Report Expense Ratio")
or
=RCHGetTableCell("http://finance.yahoo.com/q/pr?s=VBR http://finance.yahoo.com/q/pr?s=VBR",1,"Annual Report Expense Ratio")
or
=RCHGetTableCell("http://finance.yahoo.com/q/pr?s=A3 http://finance.yahoo.com/q/pr?s=VBR",1,"Annual Report Expense Ratio")
I get false, false and true as results
---In smf_addin@yahoogroups.com, <rharmelink@...> wrote:
In your formula, VBR is a cell reference. Try either of:
=RCHGetTableCell("http://finance.yahoo.com/q/pr?s= http://finance.yahoo.com/q/pr?s="&"VBR",1,"Annual Report Expense Ratio")
=RCHGetTableCell("http://finance.yahoo.com/q/pr?s=VBR http://finance.yahoo.com/q/pr?s=VBR",1,"Annual Report Expense Ratio")
On Wed, Oct 9, 2013 at 6:30 AM, <stephen.ronson@... mailto:stephen.ronson@...> wrote:
I tried to get the Expense ratio of VBR by typing in:
=RCHGetTableCell("http://finance.yahoo.com/q/pr?s= http://finance.yahoo.com/q/pr?s="&VBR,1,"Annual Report Expense Ratio")
but it returned #VALUE!
any suggestions?
but none of these work:
=RCHGetTableCell(
or
=RCHGetTableCell(
or
=RCHGetTableCell(
I get false, false and true as results
---In smf_addin@yahoogrou
In your formula, VBR is a cell reference. Try either of:
=RCHGetTableCell(
=RCHGetTableCell(
On Wed, Oct 9, 2013 at 6:30 AM, <stephen.
I tried to get the Expense ratio of VBR by typing in:
=RCHGetTableCell(
but it returned #VALUE!
any suggestions?
Thu Oct 10, 2013 8:14 am (PDT) . Posted by:
"Randy Harmelink" rharmelink
Try:
=RCHGetTableCell("http://finance.yahoo.com/q/pr?s="&A3,1,"Annual Report
Expense Ratio")
You're concatenating two strings:
"http://finance.yahoo.com/q/pr?s="
A3
But, for me, your second formula below works.
In the past, when people have gotten true/false results, it's because
they've pasted the formula incorrectly.
On Thu, Oct 10, 2013 at 7:43 AM, <stephen.ronson@gmail.com> wrote:
> I'm sorry. I'm still having trouble with this. In my excel spread
> sheet I have the letters IVE in cell A3
>
> but none of these work:
>
> =RCHGetTableCell("http://finance.yahoo.com/q/pr?s="&"A3",1,"Annual Report
> Expense Ratio")
> or
> =RCHGetTableCell("http://finance.yahoo.com/q/pr?s=VBR",1,"Annual Report
> Expense Ratio")
> or
> =RCHGetTableCell("http://finance.yahoo.com/q/pr?s=A3<http://finance.yahoo.com/q/pr?s=VBR>",1,"Annual
> Report Expense Ratio")
>
> I get false, false and true as results
>
=RCHGetTableCell(
Expense Ratio")
You're concatenating two strings:
"http://finance.
A3
But, for me, your second formula below works.
In the past, when people have gotten true/false results, it's because
they've pasted the formula incorrectly.
On Thu, Oct 10, 2013 at 7:43 AM, <stephen.ronson@
> I'm sorry. I'm still having trouble with this. In my excel spread
> sheet I have the letters IVE in cell A3
>
> but none of these work:
>
> =RCHGetTableCell(
> Expense Ratio")
> or
> =RCHGetTableCell(
> Expense Ratio")
> or
> =RCHGetTableCell(
> Report Expense Ratio")
>
> I get false, false and true as results
>
Thu Oct 10, 2013 8:32 am (PDT) . Posted by:
adas212
Hi everyone..I was wondering if someone could please help me out on this..I'm new to the plugin and just downloaded it a few days ago. So far everything has been great. I read all of the documentation and have been getting the data I need.
Recently I tried to put in a custom element in the Zacks element table. I am trying to grab 'expected earnings growth' on http://www.zacks.com/stock/quote/CNO/detailed-estimates
I put the following in the Zacks element table:
13894;Zacks;Expected Earnings Growth;=RCHGetTableCell("http://www.zacks.com/stock/quote/~~~~~/detailed-estimates",1,">Expected Earnings Growth")
I keep getting and undefined error. I saved the element and closed excel a few times just in case and entered the formula, =RCHGetElementNumber(B1,13894)
Do I need to alter the spreadsheet element file (RCHGetElementNumber) file that came with plugin?
Thanks!
Recently I tried to put in a custom element in the Zacks element table. I am trying to grab 'expected earnings growth' on http://www.zacks.
I put the following in the Zacks element table:
13894;Zacks;
I keep getting and undefined error. I saved the element and closed excel a few times just in case and entered the formula, =RCHGetElementNumbe
Do I need to alter the spreadsheet element file (RCHGetElementNumbe
Thanks!
Thu Oct 10, 2013 8:41 am (PDT) . Posted by:
"Randy Harmelink" rharmelink
Your element definition works fine here.
I'm concerned with what you refer to as the "Zacks element table". The
element definitions are in the smf-elements-*.txt files that are in the
same folder as the add-in. The XLS file is simply documentation. Nothing
more. If you delete it, the add-in would still work.
You should put your custom elements in smf-element-20.txt. The add-in loads
definitions from smf-element-0.txt, then smf-element-1.txt, then
smf-element-2.txt, ..., and lastly smf-element-20.txt.
So, then, your custom elements would override any from previous files.
You wouldn't want to put your definitions in an existing file, because then
when the add-in is updated (or if that file needs to be updated
separately), your custom definitions would go away.
You can just use the smfForceRecalculation macro to reload element
definitions. No need to exit and restart EXCEL. In fact, that was the
original reason I wrote that macro, so that I could easily test element
definition changes. For more information on that macro, see the LINKS area
of the group.
On Thu, Oct 10, 2013 at 8:25 AM, <adas212@yahoo.com> wrote:
>
> Hi everyone..I was wondering if someone could please help me out on
> this..I'm new to the plugin and just downloaded it a few days ago. So far
> everything has been great. I read all of the documentation and have been
> getting the data I need.
>
> Recently I tried to put in a custom element in the Zacks element table. I
> am trying to grab 'expected earnings growth' on
> http://www.zacks.com/stock/quote/CNO/detailed-estimates
>
> I put the following in the Zacks element table:
> 13894;Zacks;Expected Earnings Growth;=RCHGetTableCell("
> http://www.zacks.com/stock/quote/~~~~~/detailed-estimates",1,">Expected
> Earnings Growth")
>
> I keep getting and undefined error. I saved the element and closed excel a
> few times just in case and entered the formula,
> =RCHGetElementNumber(B1,13894)
>
> Do I need to alter the spreadsheet element file (RCHGetElementNumber) file
> that came with plugin?
>
I'm concerned with what you refer to as the "Zacks element table". The
element definitions are in the smf-elements-
same folder as the add-in. The XLS file is simply documentation. Nothing
more. If you delete it, the add-in would still work.
You should put your custom elements in smf-element-
definitions from smf-element-
smf-element-
So, then, your custom elements would override any from previous files.
You wouldn't want to put your definitions in an existing file, because then
when the add-in is updated (or if that file needs to be updated
separately), your custom definitions would go away.
You can just use the smfForceRecalculati
definitions. No need to exit and restart EXCEL. In fact, that was the
original reason I wrote that macro, so that I could easily test element
definition changes. For more information on that macro, see the LINKS area
of the group.
On Thu, Oct 10, 2013 at 8:25 AM, <adas212@yahoo.
>
> Hi everyone..I was wondering if someone could please help me out on
> this..I'
> everything has been great. I read all of the documentation and have been
> getting the data I need.
>
> Recently I tried to put in a custom element in the Zacks element table. I
> am trying to grab 'expected earnings growth' on
> http://www.zacks.
>
> I put the following in the Zacks element table:
> 13894;Zacks;
> http://www.zacks.
> Earnings Growth"
>
> I keep getting and undefined error. I saved the element and closed excel a
> few times just in case and entered the formula,
> =RCHGetElementNumbe
>
> Do I need to alter the spreadsheet element file (RCHGetElementNumbe
> that came with plugin?
>
Thu Oct 10, 2013 8:50 am (PDT) . Posted by:
himanshuseth@ymail.com
I am trying to update S&P 500 spreadsheet .I keep getting and undefined error. I entered the formula, =RCHGetElementNumber(cell no.,960). I tried other cell references for the stocks too but every time I am getting the same result "Error".
I am getting this for at least 400 stocks out of 500. Is there a problem with my plugin. Help would be highly appreciated.
Thanks!
---In smf_addin@yahoogroups.com, <rharmelink@...> wrote:
Your element definition works fine here.
I'm concerned with what you refer to as the "Zacks element table". The element definitions are in the smf-elements-*.txt files that are in the same folder as the add-in. The XLS file is simply documentation. Nothing more. If you delete it, the add-in would still work.
You should put your custom elements in smf-element-20.txt. The add-in loads definitions from smf-element-0.txt, then smf-element-1.txt, then smf-element-2.txt, ..., and lastly smf-element-20.txt.
So, then, your custom elements would override any from previous files.
You wouldn't want to put your definitions in an existing file, because then when the add-in is updated (or if that file needs to be updated separately), your custom definitions would go away.
You can just use the smfForceRecalculation macro to reload element definitions. No need to exit and restart EXCEL. In fact, that was the original reason I wrote that macro, so that I could easily test element definition changes. For more information on that macro, see the LINKS area of the group.
On Thu, Oct 10, 2013 at 8:25 AM, <adas212@... mailto:adas212@...> wrote:
Hi everyone..I was wondering if someone could please help me out on this..I'm new to the plugin and just downloaded it a few days ago. So far everything has been great. I read all of the documentation and have been getting the data I need.
Recently I tried to put in a custom element in the Zacks element table. I am trying to grab 'expected earnings growth' on http://www.zacks.com/stock/quote/CNO/detailed-estimates http://www.zacks.com/stock/quote/CNO/detailed-estimates
I put the following in the Zacks element table:
13894;Zacks;Expected Earnings Growth;=RCHGetTableCell("http://www.zacks.com/stock/quote/~~~~~/detailed-estimates http://www.zacks.com/stock/quote/~~~~~/detailed-estimates",1,">Expected Earnings Growth")
I keep getting and undefined error. I saved the element and closed excel a few times just in case and entered the formula, =RCHGetElementNumber(B1,13894)
Do I need to alter the spreadsheet element file (RCHGetElementNumber) file that came with plugin?
I am getting this for at least 400 stocks out of 500. Is there a problem with my plugin. Help would be highly appreciated.
Thanks!
---In smf_addin@yahoogrou
Your element definition works fine here.
I'm concerned with what you refer to as the "Zacks element table". The element definitions are in the smf-elements-
You should put your custom elements in smf-element-
So, then, your custom elements would override any from previous files.
You wouldn't want to put your definitions in an existing file, because then when the add-in is updated (or if that file needs to be updated separately), your custom definitions would go away.
You can just use the smfForceRecalculati
On Thu, Oct 10, 2013 at 8:25 AM, <adas212@
Hi everyone..I was wondering if someone could please help me out on this..I'
Recently I tried to put in a custom element in the Zacks element table. I am trying to grab 'expected earnings growth' on http://www.zacks.
I put the following in the Zacks element table:
13894;Zacks;
I keep getting and undefined error. I saved the element and closed excel a few times just in case and entered the formula, =RCHGetElementNumbe
Do I need to alter the spreadsheet element file (RCHGetElementNumbe
Thu Oct 10, 2013 9:02 am (PDT) . Posted by:
"Randy Harmelink" rharmelink
If you're getting "Undefined" returned, it means you didn't unzip all of
the contents of the ZIP file into the same folder. The smf-element-*.txt
files contain the element definitions. If they aren't in the same folder as
the add-in, no element will be defined.
Note that the add-in isn't designed for bulk downloading and has a
limitation of retrieving data from only 1000 web pages per "session". All
further web page extractions will return and error message indicating "too
many page retrievals".
On Thu, Oct 10, 2013 at 8:50 AM, <himanshuseth@ymail.com> wrote:
> I am trying to update S&P 500 spreadsheet .I keep getting and undefined
> error. I entered the formula, =RCHGetElementNumber(cell no.,960). I tried
> other cell references for the stocks too but every time I am getting the
> same result "Error".
>
> I am getting this for at least 400 stocks out of 500. Is there a problem
> with my plugin. Help would be highly appreciated.
>
the contents of the ZIP file into the same folder. The smf-element-
files contain the element definitions. If they aren't in the same folder as
the add-in, no element will be defined.
Note that the add-in isn't designed for bulk downloading and has a
limitation of retrieving data from only 1000 web pages per "session"
further web page extractions will return and error message indicating "too
many page retrievals"
On Thu, Oct 10, 2013 at 8:50 AM, <himanshuseth@
> I am trying to update S&P 500 spreadsheet .I keep getting and undefined
> error. I entered the formula, =RCHGetElementNumbe
> other cell references for the stocks too but every time I am getting the
> same result "Error"
>
> I am getting this for at least 400 stocks out of 500. Is there a problem
> with my plugin. Help would be highly appreciated.
>
Thu Oct 10, 2013 10:50 am (PDT) . Posted by:
adas212
Hi Randy,
Thank you. I just moved all custom elements to smf-element-20.txt. I also tried executing the command to retrieve the 'expected earnings growth' field and it worked! Thank you.
Okay, I wasnt sure about excel file that came with the plugin. Thanks for the clarification.
Randy, could I ask one more question.
I wanted to retrieve the key stats data on this page http://quotes.morningstar.com/stock/cno/s?t=cno
I need the p/b p/s p/e and other information in that table. I understand from reviewing previous conversations that Morningstars webpages are dynamic now and that the plugin has issues with some of the data.
I was able to pull in spreadsheet data via the export button as you described in a previous conversation by executing an array. So thats working great but is there any way to retrieve the key stats data on http://quotes.morningstar.com/stock/cno/s?t=cno.
I havent tried creating the code yet but i figured I would ask first.
Thank you Randy for your help and time and thanks for creating the plugin too!
---In smf_addin@yahoogroups.com, <rharmelink@...> wrote:
Your element definition works fine here.
I'm concerned with what you refer to as the "Zacks element table". The element definitions are in the smf-elements-*.txt files that are in the same folder as the add-in. The XLS file is simply documentation. Nothing more. If you delete it, the add-in would still work.
You should put your custom elements in smf-element-20.txt. The add-in loads definitions from smf-element-0.txt, then smf-element-1.txt, then smf-element-2.txt, ..., and lastly smf-element-20.txt.
So, then, your custom elements would override any from previous files.
You wouldn't want to put your definitions in an existing file, because then when the add-in is updated (or if that file needs to be updated separately), your custom definitions would go away.
You can just use the smfForceRecalculation macro to reload element definitions. No need to exit and restart EXCEL. In fact, that was the original reason I wrote that macro, so that I could easily test element definition changes. For more information on that macro, see the LINKS area of the group.
On Thu, Oct 10, 2013 at 8:25 AM, <adas212@... mailto:adas212@...> wrote:
Hi everyone..I was wondering if someone could please help me out on this..I'm new to the plugin and just downloaded it a few days ago. So far everything has been great. I read all of the documentation and have been getting the data I need.
Recently I tried to put in a custom element in the Zacks element table. I am trying to grab 'expected earnings growth' on http://www.zacks.com/stock/quote/CNO/detailed-estimates http://www.zacks.com/stock/quote/CNO/detailed-estimates
I put the following in the Zacks element table:
13894;Zacks;Expected Earnings Growth;=RCHGetTableCell("http://www.zacks.com/stock/quote/~~~~~/detailed-estimates http://www.zacks.com/stock/quote/~~~~~/detailed-estimates",1,">Expected Earnings Growth")
I keep getting and undefined error. I saved the element and closed excel a few times just in case and entered the formula, =RCHGetElementNumber(B1,13894)
Do I need to alter the spreadsheet element file (RCHGetElementNumber) file that came with plugin?
Thank you. I just moved all custom elements to smf-element-
Okay, I wasnt sure about excel file that came with the plugin. Thanks for the clarification.
Randy, could I ask one more question.
I wanted to retrieve the key stats data on this page http://quotes.
I need the p/b p/s p/e and other information in that table. I understand from reviewing previous conversations that Morningstars webpages are dynamic now and that the plugin has issues with some of the data.
I was able to pull in spreadsheet data via the export button as you described in a previous conversation by executing an array. So thats working great but is there any way to retrieve the key stats data on http://quotes.
I havent tried creating the code yet but i figured I would ask first.
Thank you Randy for your help and time and thanks for creating the plugin too!
---In smf_addin@yahoogrou
Your element definition works fine here.
I'm concerned with what you refer to as the "Zacks element table". The element definitions are in the smf-elements-
You should put your custom elements in smf-element-
So, then, your custom elements would override any from previous files.
You wouldn't want to put your definitions in an existing file, because then when the add-in is updated (or if that file needs to be updated separately), your custom definitions would go away.
You can just use the smfForceRecalculati
On Thu, Oct 10, 2013 at 8:25 AM, <adas212@
Hi everyone..I was wondering if someone could please help me out on this..I'
Recently I tried to put in a custom element in the Zacks element table. I am trying to grab 'expected earnings growth' on http://www.zacks.
I put the following in the Zacks element table:
13894;Zacks;
I keep getting and undefined error. I saved the element and closed excel a few times just in case and entered the formula, =RCHGetElementNumbe
Do I need to alter the spreadsheet element file (RCHGetElementNumbe
Thu Oct 10, 2013 10:56 am (PDT) . Posted by:
"Randy Harmelink" rharmelink
The dynamic web page sources this web page to get those Key Stats:
http://quotes.morningstar.com/stock/c-keystats?t=CNO
So you can pull them from there. For example:
=RCHGetTableCell("http://quotes.morningstar.com/stock/c-keystats?t=CNO
",1,"Price/Earnings")
It's just one of over a dozen "static" data pages that the "dynamic" page
uses to present the data.
On Thu, Oct 10, 2013 at 10:50 AM, <adas212@yahoo.com> wrote:
> I wanted to retrieve the key stats data on this page
> http://quotes.morningstar.com/stock/cno/s?t=cno
>
> I need the p/b p/s p/e and other information in that table. I understand
> from reviewing previous conversations that Morningstars webpages are
> dynamic now and that the plugin has issues with some of the data.
>
> I was able to pull in spreadsheet data via the export button as you
> described in a previous conversation by executing an array. So thats
> working great but is there any way to retrieve the key stats data on
> http://quotes.morningstar.com/stock/cno/s?t=cno.
>
> I havent tried creating the code yet but i figured I would ask first.
>
>
http://quotes.
So you can pull them from there. For example:
=RCHGetTableCell(
",1,"
It's just one of over a dozen "static" data pages that the "dynamic" page
uses to present the data.
On Thu, Oct 10, 2013 at 10:50 AM, <adas212@yahoo.
> I wanted to retrieve the key stats data on this page
> http://quotes.
>
> I need the p/b p/s p/e and other information in that table. I understand
> from reviewing previous conversations that Morningstars webpages are
> dynamic now and that the plugin has issues with some of the data.
>
> I was able to pull in spreadsheet data via the export button as you
> described in a previous conversation by executing an array. So thats
> working great but is there any way to retrieve the key stats data on
> http://quotes.
>
> I havent tried creating the code yet but i figured I would ask first.
>
>
Thu Oct 10, 2013 2:31 pm (PDT) . Posted by:
freefaller6
Hi Randy, first, thanks for your help. I haven't ran through a spreadsheet since May 2013. At that time, I had no issues. I just pulled it up to check on the thing and it's full of errors. So I see now those values relying on the AdvFN have a new document defining how to set up formulas for this source.
Is this new since May 2013?
Thanks again,
Brent
Is this new since May 2013?
Thanks again,
Brent
Thu Oct 10, 2013 4:21 pm (PDT) . Posted by:
freefaller6
Hello all,
With AdvFN on the fritz, I see some have suggested using gurufocus. Would you someone help me with an example to get me started?
For example, if I wanted to pull the ROIC for Apple, for year 1, using AdvFN element 7786, I would go to a cell and type =RCHGetElementNumber("aapl",7786).
What do I need to type to get the same info if pulling from Gurufocus?
I am using a PC, XP operating system, Excel 2010.
Much obliged!
With AdvFN on the fritz, I see some have suggested using gurufocus. Would you someone help me with an example to get me started?
For example, if I wanted to pull the ROIC for Apple, for year 1, using AdvFN element 7786, I would go to a cell and type =RCHGetElementNumbe
What do I need to type to get the same info if pulling from Gurufocus?
I am using a PC, XP operating system, Excel 2010.
Much obliged!
Thu Oct 10, 2013 4:30 pm (PDT) . Posted by:
"Randy Harmelink" rharmelink
I'd suggest grabbing the Guru Focus example from the files area of the
group.
However, there is no single definition of ROIC. It can be calculated a
number of ways. I don't think you'll find an exact match on GuruFocus.
On Thu, Oct 10, 2013 at 4:21 PM, <freefaller6@yahoo.com> wrote:
>
> With AdvFN on the fritz, I see some have suggested using gurufocus. Would
> you someone help me with an example to get me started?
>
> For example, if I wanted to pull the ROIC for Apple, for year 1, using
> AdvFN element 7786, I would go to a cell and type
> =RCHGetElementNumber("aapl",7786).
>
> What do I need to type to get the same info if pulling from Gurufocus?
>
> I am using a PC, XP operating system, Excel 2010.
>
group.
However, there is no single definition of ROIC. It can be calculated a
number of ways. I don't think you'll find an exact match on GuruFocus.
On Thu, Oct 10, 2013 at 4:21 PM, <freefaller6@
>
> With AdvFN on the fritz, I see some have suggested using gurufocus. Would
> you someone help me with an example to get me started?
>
> For example, if I wanted to pull the ROIC for Apple, for year 1, using
> AdvFN element 7786, I would go to a cell and type
> =RCHGetElementNumbe
>
> What do I need to type to get the same info if pulling from Gurufocus?
>
> I am using a PC, XP operating system, Excel 2010.
>
Thu Oct 10, 2013 5:04 pm (PDT) . Posted by:
freefaller6
Thanks Randy. Do you expect the AdvFN to eventually be restored? The sheet I built really needs to pull several pieces of AdvFN information from multiple stocks at once, manipulate it, and spit out the results. This add-in is the only tool I have found that can pull historical stock data like it does. I am potentially in a bit of heap without it.
Thanks again,
Brent
---In smf_addin@yahoogroups.com, <rharmelink@...> wrote:
I'd suggest grabbing the Guru Focus example from the files area of the group.
However, there is no single definition of ROIC. It can be calculated a number of ways. I don't think you'll find an exact match on GuruFocus.
On Thu, Oct 10, 2013 at 4:21 PM, <freefaller6@... mailto:freefaller6@...> wrote:
With AdvFN on the fritz, I see some have suggested using gurufocus. Would you someone help me with an example to get me started?
For example, if I wanted to pull the ROIC for Apple, for year 1, using AdvFN element 7786, I would go to a cell and type =RCHGetElementNumber("aapl",7786).
What do I need to type to get the same info if pulling from Gurufocus?
I am using a PC, XP operating system, Excel 2010.
Thanks again,
Brent
---In smf_addin@yahoogrou
I'd suggest grabbing the Guru Focus example from the files area of the group.
However, there is no single definition of ROIC. It can be calculated a number of ways. I don't think you'll find an exact match on GuruFocus.
On Thu, Oct 10, 2013 at 4:21 PM, <freefaller6@
With AdvFN on the fritz, I see some have suggested using gurufocus. Would you someone help me with an example to get me started?
For example, if I wanted to pull the ROIC for Apple, for year 1, using AdvFN element 7786, I would go to a cell and type =RCHGetElementNumbe
What do I need to type to get the same info if pulling from Gurufocus?
I am using a PC, XP operating system, Excel 2010.
Thu Oct 10, 2013 5:30 pm (PDT) . Posted by:
"Randy Harmelink" rharmelink
Rumors that have been posted here are that the new format will be something
like:
http://www.advfn.com/common/financial/NYSE/3m-co-MMM/full-financials?pm=Q&isfull=1&bsfull=1&cffull=1&effull=1&vrfull=1&grfull=1&fhfull=1&prfull=1
http://www.advfn.com/common/financial/NYSE/3m-co-MMM/full-financials?pm=A&isfull=1&bsfull=1&cffull=1&effull=1&vrfull=1&grfull=1&fhfull=1&prfull=1
But when? No clue.
You could do something like this to get quarterly ROIC from the new beta
format:
=RCHGetTableCell("http://www.advfn.com/common/financial/"&D14&"/dummy-"&D13&"/full-financials?pm=Q&isfull=1&bsfull=1&cffull=1&effull=1&vrfull=1&grfull=1&fhfull=1&prfull=1",1,"Efficiency
Ratios Page",">ROIC")
...where D14 contains the exchange and D14 contains the ticker symbol.
On Thu, Oct 10, 2013 at 5:04 PM, <freefaller6@yahoo.com> wrote:
> Thanks Randy. Do you expect the AdvFN to eventually be restored? The
> sheet I built really needs to pull several pieces of AdvFN information from
> multiple stocks at once, manipulate it, and spit out the results. This
> add-in is the only tool I have found that can pull historical stock data
> like it does. I am potentially in a bit of heap without it.
>
like:
http://www.advfn.
http://www.advfn.
But when? No clue.
You could do something like this to get quarterly ROIC from the new beta
format:
=RCHGetTableCell(
Ratios Page","
...where D14 contains the exchange and D14 contains the ticker symbol.
On Thu, Oct 10, 2013 at 5:04 PM, <freefaller6@
> Thanks Randy. Do you expect the AdvFN to eventually be restored? The
> sheet I built really needs to pull several pieces of AdvFN information from
> multiple stocks at once, manipulate it, and spit out the results. This
> add-in is the only tool I have found that can pull historical stock data
> like it does. I am potentially in a bit of heap without it.
>
Thu Oct 10, 2013 5:46 pm (PDT) . Posted by:
freefaller6
Cool, I'll check it out, but your knowledge of code far exceeds mine. Are you open to a 10 minute webex next week? It may make more sense if I show you what I am doing. Basically, I built a sheet based on P. Town's Rule Number 1 to identify stocks that are currently undervalued. It's worked really well since March. I see Element 15012 is also set up to calculate the Rule Number 1 price too; I am curious where that is pulled from?
I'll understand if that's a bit too much support, but let me know if you're interested in the webex and we can coordinate a good time.
Thanks again,
Brent
---In smf_addin@yahoogroups.com, <smf_addin@yahoogroups.com> wrote:
Rumors that have been posted here are that the new format will be something like:
http://www.advfn.com/common/financial/NYSE/3m-co-MMM/full-financials?pm=Q&isfull=1&bsfull=1&cffull=1&effull=1&vrfull=1&grfull=1&fhfull=1&prfull=1 http://www.advfn.com/common/financial/NYSE/3m-co-MMM/full-financials?pm=Q&isfull=1&bsfull=1&cffull=1&effull=1&vrfull=1&grfull=1&fhfull=1&prfull=1
http://www.advfn.com/common/financial/NYSE/3m-co-MMM/full-financials?pm=A&isfull=1&bsfull=1&cffull=1&effull=1&vrfull=1&grfull=1&fhfull=1&prfull=1 http://www.advfn.com/common/financial/NYSE/3m-co-MMM/full-financials?pm=A&isfull=1&bsfull=1&cffull=1&effull=1&vrfull=1&grfull=1&fhfull=1&prfull=1
But when? No clue.
You could do something like this to get quarterly ROIC from the new beta format:
=RCHGetTableCell("http://www.advfn.com/common/financial/ http://www.advfn.com/common/financial/"&D14&"/dummy-"&D13&"/full-financials?pm=Q&isfull=1&bsfull=1&cffull=1&effull=1&vrfull=1&grfull=1&fhfull=1&prfull=1",1,"Efficiency Ratios Page",">ROIC")
...where D14 contains the exchange and D14 contains the ticker symbol.
On Thu, Oct 10, 2013 at 5:04 PM, <freefaller6@... mailto:freefaller6@...> wrote:
Thanks Randy. Do you expect the AdvFN to eventually be restored? The sheet I built really needs to pull several pieces of AdvFN information from multiple stocks at once, manipulate it, and spit out the results. This add-in is the only tool I have found that can pull historical stock data like it does. I am potentially in a bit of heap without it.
I'll understand if that's a bit too much support, but let me know if you're interested in the webex and we can coordinate a good time.
Thanks again,
Brent
---In smf_addin@yahoogrou
Rumors that have been posted here are that the new format will be something like:
http://www.advfn.
http://www.advfn.
But when? No clue.
You could do something like this to get quarterly ROIC from the new beta format:
=RCHGetTableCell(
...where D14 contains the exchange and D14 contains the ticker symbol.
On Thu, Oct 10, 2013 at 5:04 PM, <freefaller6@
Thanks Randy. Do you expect the AdvFN to eventually be restored? The sheet I built really needs to pull several pieces of AdvFN information from multiple stocks at once, manipulate it, and spit out the results. This add-in is the only tool I have found that can pull historical stock data like it does. I am potentially in a bit of heap without it.
Thu Oct 10, 2013 6:45 pm (PDT) . Posted by:
dbltapp00
I'd really appreciate anyone telling me why these don't work in Excel 2007:
=smfGetOptionQuotes( "AMT Oct 2013 $75 Call", "a",1)
=smfGetYahooOptionQuote( "AMT","C",DATE(2013,10,19),75,"l")
They both return #NAME?. Using smf version 2.0j
Thanks
=smfGetOptionQuotes
=smfGetYahooOptionQ
They both return #NAME?. Using smf version 2.0j
Thanks
Tidak ada komentar:
Posting Komentar