15 New Messages
Digest #2832
Messages
Wed Oct 30, 2013 1:27 am (PDT) . Posted by:
"Randy Harmelink" rharmelink
AdvFN won't work unless you're using the beta version of the add-in from
the "Works in Progress" folder. A major topic of conversation on this group
for that last few months has been over changes at AdvFN. And there are more
to come.
I just tried the Google Cash Flows template workbook from the FILES area of
the group and all of the elements on it are working for me, using ticker
symbol MMM.
On Tue, Oct 29, 2013 at 5:44 PM, <clay.paschall@yahoo.com> wrote:
>
> Unfortunately,it seems the elements from google/advFn no longer work. Is
> there an updated elements list or somewhere else for Stmt. of Cashflows
> information?
>
the "Works in Progress" folder. A major topic of conversation on this group
for that last few months has been over changes at AdvFN. And there are more
to come.
I just tried the Google Cash Flows template workbook from the FILES area of
the group and all of the elements on it are working for me, using ticker
symbol MMM.
On Tue, Oct 29, 2013 at 5:44 PM, <clay.paschall@
>
> Unfortunately,
> there an updated elements list or somewhere else for Stmt. of Cashflows
> information?
>
Wed Oct 30, 2013 9:41 am (PDT) . Posted by:
clay.paschall
Thanks Randy,
I quickly got caught up after running through the board. I've tried the new beta download. Both AdvFN & Google elements continue to give the infamous "Error" message outside the templates provided in Files.
---In smf_addin@yahoogroups.com, <rharmelink@...> wrote:
AdvFN won't work unless you're using the beta version of the add-in from the "Works in Progress" folder. A major topic of conversation on this group for that last few months has been over changes at AdvFN. And there are more to come.
I just tried the Google Cash Flows template workbook from the FILES area of the group and all of the elements on it are working for me, using ticker symbol MMM.
On Tue, Oct 29, 2013 at 5:44 PM, <clay.paschall@... mailto:clay.paschall@...> wrote:
Unfortunately,it seems the elements from google/advFn no longer work. Is there an updated elements list or somewhere else for Stmt. of Cashflows information?
I quickly got caught up after running through the board. I've tried the new beta download. Both AdvFN & Google elements continue to give the infamous "Error" message outside the templates provided in Files.
---In smf_addin@yahoogrou
AdvFN won't work unless you're using the beta version of the add-in from the "Works in Progress" folder. A major topic of conversation on this group for that last few months has been over changes at AdvFN. And there are more to come.
I just tried the Google Cash Flows template workbook from the FILES area of the group and all of the elements on it are working for me, using ticker symbol MMM.
On Tue, Oct 29, 2013 at 5:44 PM, <clay.paschall@
Unfortunately,
Wed Oct 30, 2013 11:24 am (PDT) . Posted by:
"Randy Harmelink" rharmelink
But they worked *in* the templates?
On Wed, Oct 30, 2013 at 9:41 AM, <clay.paschall@yahoo.com> wrote:
> I quickly got caught up after running through the board. I've tried the
> new beta download. Both AdvFN & Google elements continue to give the
> infamous "Error" message outside the templates provided in Files.
>
On Wed, Oct 30, 2013 at 9:41 AM, <clay.paschall@
> I quickly got caught up after running through the board. I've tried the
> new beta download. Both AdvFN & Google elements continue to give the
> infamous "Error" message outside the templates provided in Files.
>
Wed Oct 30, 2013 1:14 pm (PDT) . Posted by:
clay.paschall
Actually the Google template does not work. The AdvFN template does work but it's not using the elements given in element library. It's using a different cell-code.
---In smf_addin@yahoogroups.com, <rharmelink@...> wrote:
But they worked *in* the templates?
On Wed, Oct 30, 2013 at 9:41 AM, <clay.paschall@... mailto:clay.paschall@...> wrote:
I quickly got caught up after running through the board. I've tried the new beta download. Both AdvFN & Google elements continue to give the infamous "Error" message outside the templates provided in Files.
---In smf_addin@yahoogrou
But they worked *in* the templates?
On Wed, Oct 30, 2013 at 9:41 AM, <clay.paschall@
I quickly got caught up after running through the board. I've tried the new beta download. Both AdvFN & Google elements continue to give the infamous "Error" message outside the templates provided in Files.
Wed Oct 30, 2013 3:37 pm (PDT) . Posted by:
"Randy Harmelink" rharmelink
Can you give me an example of "it's not using the elements given in element
library. It's using a different cell-code"?
As for Google, what do you get with:
=RCHGetElementNumber("MMM";, 3854)
=RCHGetElementNumber("Version")
=smfGetAParms(3854)
=RCHGetTableCell("http://www.google.com/finance?fstype=ii&q=MMM",
1,"CASANNUALDIV","(except for per share items)")
=RCHGetWebData("http://www.google.com/finance?fstype=ii&q=MMM",,50)
And, using the EXCEL Web Query dialog (keyboard shortcut alt+d+d+w), do you
see the financial statements data when you visit:
http://www.google.com/finance?fstype=ii&q=MMM
On Wed, Oct 30, 2013 at 1:14 PM, <clay.paschall@yahoo.com> wrote:
> Actually the Google template does not work. The AdvFN template does work
> but it's not using the elements given in element library. It's using a
> different cell-code.
>
library. It's using a different cell-code"
As for Google, what do you get with:
=RCHGetElementNumbe
=RCHGetElementNumbe
=smfGetAParms(
=RCHGetTableCell(
1,"CASANNUALDI
=RCHGetWebData(
And, using the EXCEL Web Query dialog (keyboard shortcut alt+d+d+w), do you
see the financial statements data when you visit:
http://www.google.
On Wed, Oct 30, 2013 at 1:14 PM, <clay.paschall@
> Actually the Google template does not work. The AdvFN template does work
> but it's not using the elements given in element library. It's using a
> different cell-code.
>
Wed Oct 30, 2013 3:19 am (PDT) . Posted by:
"Jim Ranum" amt2100
Hi Randy,
I've been using the same spreadsheet successfully for a couple months now
and all of a sudden this morning I'm getting erroneous numbers.
Example is SKYW. (but it's the same for all tickers)
Same formula for months. The correct number is: 1411, but I'm getting .33
No changes to my computer I know of. RCHGetYahooQuotes is still giving
accurate numbers. Same problem on another computer. Seems to be something
with gurufocus.
Any help is greatly appreciated.
Thank you,
Jim
I've been using the same spreadsheet successfully for a couple months now
and all of a sudden this morning I'm getting erroneous numbers.
Example is SKYW. (but it's the same for all tickers)
Same formula for months. The correct number is: 1411, but I'm getting .33
No changes to my computer I know of. RCHGetYahooQuotes is still giving
accurate numbers. Same problem on another computer. Seems to be something
with gurufocus.
Any help is greatly appreciated.
Thank you,
Jim
Wed Oct 30, 2013 5:06 am (PDT) . Posted by:
"Randy Harmelink" rharmelink
It's because they've added a line item of "Total Equity to Total Asset" to
the "Ratios" section, so that's the ">Total Equity" you're finding.
Any of the following should fix the problem:
=RCHGetTableCell("http://www.gurufocus.com/financials/"&C7,11,">Fiscal
Period",">Balance Sheet",">Total Equity")
=RCHGetTableCell("http://www.gurufocus.com/financials/"&C5,11,">Fiscal
Period","/Total Equity/")
=RCHGetTableCell("http://www.gurufocus.com/financials/"&C4,11,">Fiscal
Period",">Total Equity<")
=RCHGetTableCell("http://www.gurufocus.com/financials/"&C6,11,">Fiscal
Period",">Total Equity",">Total Equity")
On Wed, Oct 30, 2013 at 3:19 AM, Jim Ranum <amt2100@gmail.com> wrote:
>
>
> I've been using the same spreadsheet successfully for a couple months now
> and all of a sudden this morning I'm getting erroneous numbers.****
>
> ** **
>
> Example is SKYW. (but it's the same for all tickers)****
>
> ** **
>
> ****
>
> ** **
>
> Same formula for months. The correct number is: 1411, but I'm getting .33
> ****
>
> ** **
>
> No changes to my computer I know of. RCHGetYahooQuotes is still giving
> accurate numbers. Same problem on another computer. Seems to be something
> with gurufocus.****
>
> Any help is greatly appreciated.****
>
>
the "Ratios" section, so that's the ">Total Equity" you're finding.
Any of the following should fix the problem:
=RCHGetTableCell(
Period"
=RCHGetTableCell(
Period"
=RCHGetTableCell(
Period"
=RCHGetTableCell(
Period"
On Wed, Oct 30, 2013 at 3:19 AM, Jim Ranum <amt2100@gmail.
>
>
> I've been using the same spreadsheet successfully for a couple months now
> and all of a sudden this morning I'm getting erroneous numbers.****
>
> ** **
>
> Example is SKYW. (but it's the same for all tickers)****
>
> ** **
>
> ****
>
> ** **
>
> Same formula for months. The correct number is: 1411, but I'm getting .33
> ****
>
> ** **
>
> No changes to my computer I know of. RCHGetYahooQuotes is still giving
> accurate numbers. Same problem on another computer. Seems to be something
> with gurufocus.**
>
> Any help is greatly appreciated.
>
>
Wed Oct 30, 2013 5:23 am (PDT) . Posted by:
"Jim Ranum" amt2100
Awesome.
Thanks very much.
Jim
From: smf_addin@yahoogroups.com [mailto:smf_addin@yahoogroups.com] On Behalf Of Randy Harmelink
Sent: Wednesday, October 30, 2013 8:07 AM
To: smf_addin@yahoogroups.com
Subject: Re: [smf_addin] Gurufocus problems
It's because they've added a line item of "Total Equity to Total Asset" to the "Ratios" section, so that's the ">Total Equity" you're finding.
Any of the following should fix the problem:
=RCHGetTableCell("http://www.gurufocus.com/financials/"&C7,11,">Fiscal Period",">Balance Sheet",">Total Equity")
=RCHGetTableCell("http://www.gurufocus.com/financials/"&C5,11,">Fiscal Period","/Total Equity/")
=RCHGetTableCell("http://www.gurufocus.com/financials/"&C4,11,">Fiscal Period",">Total Equity<")
=RCHGetTableCell("http://www.gurufocus.com/financials/"&C6,11,">Fiscal Period",">Total Equity",">Total Equity")
On Wed, Oct 30, 2013 at 3:19 AM, Jim Ranum <amt2100@gmail.com> wrote:
I've been using the same spreadsheet successfully for a couple months now and all of a sudden this morning I'm getting erroneous numbers.
Example is SKYW. (but it's the same for all tickers)
Same formula for months. The correct number is: 1411, but I'm getting .33
No changes to my computer I know of. RCHGetYahooQuotes is still giving accurate numbers. Same problem on another computer. Seems to be something with gurufocus.
Any help is greatly appreciated.
Thanks very much.
Jim
From: smf_addin@yahoogrou
Sent: Wednesday, October 30, 2013 8:07 AM
To: smf_addin@yahoogrou
Subject: Re: [smf_addin] Gurufocus problems
It's because they've added a line item of "Total Equity to Total Asset" to the "Ratios" section, so that's the ">Total Equity" you're finding.
Any of the following should fix the problem:
=RCHGetTableCell(
=RCHGetTableCell(
=RCHGetTableCell(
=RCHGetTableCell(
On Wed, Oct 30, 2013 at 3:19 AM, Jim Ranum <amt2100@gmail.
I've been using the same spreadsheet successfully for a couple months now and all of a sudden this morning I'm getting erroneous numbers.
Example is SKYW. (but it's the same for all tickers)
Same formula for months. The correct number is: 1411, but I'm getting .33
No changes to my computer I know of. RCHGetYahooQuotes is still giving accurate numbers. Same problem on another computer. Seems to be something with gurufocus.
Any help is greatly appreciated.
Wed Oct 30, 2013 7:00 am (PDT) . Posted by:
"Jim Ranum" amt2100
Just a little feedback on this.
This one did Not work:
=RCHGetTableCell("http://www.gurufocus.com/financials/"&C5,11,">Fiscal Period","/Total Equity/")
This one Did work:
=RCHGetTableCell("http://www.gurufocus.com/financials/"&C4,11,">Fiscal Period",">Total Equity<")
All it needed was a " < " at the end of the Total Equity field.
Those are the things that make me crazy.
Thanks again Randy.
Jim
I didn't try the other 2 options.
From: smf_addin@yahoogroups.com [mailto:smf_addin@yahoogroups.com] On Behalf Of Randy Harmelink
Sent: Wednesday, October 30, 2013 8:07 AM
To: smf_addin@yahoogroups.com
Subject: Re: [smf_addin] Gurufocus problems
It's because they've added a line item of "Total Equity to Total Asset" to the "Ratios" section, so that's the ">Total Equity" you're finding.
Any of the following should fix the problem:
=RCHGetTableCell("http://www.gurufocus.com/financials/"&C7,11,">Fiscal Period",">Balance Sheet",">Total Equity")
=RCHGetTableCell("http://www.gurufocus.com/financials/"&C5,11,">Fiscal Period","/Total Equity/")
=RCHGetTableCell("http://www.gurufocus.com/financials/"&C4,11,">Fiscal Period",">Total Equity<")
=RCHGetTableCell("http://www.gurufocus.com/financials/"&C6,11,">Fiscal Period",">Total Equity",">Total Equity")
On Wed, Oct 30, 2013 at 3:19 AM, Jim Ranum <amt2100@gmail.com> wrote:
I've been using the same spreadsheet successfully for a couple months now and all of a sudden this morning I'm getting erroneous numbers.
Example is SKYW. (but it's the same for all tickers)
Same formula for months. The correct number is: 1411, but I'm getting .33
No changes to my computer I know of. RCHGetYahooQuotes is still giving accurate numbers. Same problem on another computer. Seems to be something with gurufocus.
Any help is greatly appreciated.
This one did Not work:
=RCHGetTableCell(
This one Did work:
=RCHGetTableCell(
All it needed was a " < " at the end of the Total Equity field.
Those are the things that make me crazy.
Thanks again Randy.
Jim
I didn't try the other 2 options.
From: smf_addin@yahoogrou
Sent: Wednesday, October 30, 2013 8:07 AM
To: smf_addin@yahoogrou
Subject: Re: [smf_addin] Gurufocus problems
It's because they've added a line item of "Total Equity to Total Asset" to the "Ratios" section, so that's the ">Total Equity" you're finding.
Any of the following should fix the problem:
=RCHGetTableCell(
=RCHGetTableCell(
=RCHGetTableCell(
=RCHGetTableCell(
On Wed, Oct 30, 2013 at 3:19 AM, Jim Ranum <amt2100@gmail.
I've been using the same spreadsheet successfully for a couple months now and all of a sudden this morning I'm getting erroneous numbers.
Example is SKYW. (but it's the same for all tickers)
Same formula for months. The correct number is: 1411, but I'm getting .33
No changes to my computer I know of. RCHGetYahooQuotes is still giving accurate numbers. Same problem on another computer. Seems to be something with gurufocus.
Any help is greatly appreciated.
Wed Oct 30, 2013 11:28 am (PDT) . Posted by:
joshi_mandar
I have been using the SMF-addin for several months now and loving it. But right now I am using it with MS-Excel. Excel has it's own limitations. I am wondering if it can be used with MS-Access database. Has anyone tried?
Wed Oct 30, 2013 3:12 pm (PDT) . Posted by:
gardenfreak14
I'd love it if someone has created something for MS Access!!!
---In smf_addin@yahoogroups.com, <smf_addin@yahoogroups.com> wrote:
I have been using the SMF-addin for several months now and loving it. But right now I am using it with MS-Excel. Excel has it's own limitations. I am wondering if it can be used with MS-Access database. Has anyone tried?
---In smf_addin@yahoogrou
I have been using the SMF-addin for several months now and loving it. But right now I am using it with MS-Excel. Excel has it's own limitations. I am wondering if it can be used with MS-Access database. Has anyone tried?
Wed Oct 30, 2013 3:40 pm (PDT) . Posted by:
"Randy Harmelink" rharmelink
My concern is that if you need it for MS Access, to get around EXCEL
limitations, you're probably downloading way too much data. These websites
can turn off the ability to get at their data. The Motley Fool just
recently made their web pages inaccessible to something like the add-in.
On Wed, Oct 30, 2013 at 11:28 AM, <joshi_mandar@hotmail.com> wrote:
>
> I have been using the SMF-addin for several months now and loving it. But
> right now I am using it with MS-Excel. Excel has it's own limitations. I
> am wondering if it can be used with MS-Access database. Has anyone tried?
>
limitations, you're probably downloading way too much data. These websites
can turn off the ability to get at their data. The Motley Fool just
recently made their web pages inaccessible to something like the add-in.
On Wed, Oct 30, 2013 at 11:28 AM, <joshi_mandar@
>
> I have been using the SMF-addin for several months now and loving it. But
> right now I am using it with MS-Excel. Excel has it's own limitations. I
> am wondering if it can be used with MS-Access database. Has anyone tried?
>
Wed Oct 30, 2013 12:19 pm (PDT) . Posted by:
"c1sander" c1sander
Randy,
I opened up the site from Excel and the formula (after forced recalculation) still gives an error. Is there something that might be preventing the creation of the cookie?
Thanks for your help.
Craig
--- In smf_addin@yahoogroups.com, Randy Harmelink <rharmelink@...> wrote:
>
> 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@...> 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?
> >
>
I opened up the site from Excel and the formula (after forced recalculation) still gives an error. Is there something that might be preventing the creation of the cookie?
Thanks for your help.
Craig
--- In smf_addin@yahoogrou
>
> Try doing it with your EXCEL Web Query dialog (alt+d+d+w), and then run the
> 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?
> >
>
Wed Oct 30, 2013 3:26 pm (PDT) . Posted by:
"Randy Harmelink" rharmelink
You need to do more than just open the site. You actually have to go to a
quotes page. Because the quotes page is displaying a frame of data from
iVolatility.com. The process needs a security cookies so data can be
retrieved from their website. So just opening 888options.com (and their
redirection), won't work.
The actual web page it might end up using is something like:
http://oic.ivolatility.com/oic_adv_options.j?exp_date=-1&ticker=SPY
If you bookmark that URL and try to visit it after the security cookie has
expired, it won't work at all. Try visiting that web page with the EXCEL
Web Query dialog and see if you see option quotes and volatility
information.
On Wed, Oct 30, 2013 at 12:19 PM, c1sander <craig.sander@comcast.net> wrote:
>
> I opened up the site from Excel and the formula (after forced
> recalculation) still gives an error. Is there something that might be
> preventing the creation of the cookie?
>
quotes page. Because the quotes page is displaying a frame of data from
iVolatility.
retrieved from their website. So just opening 888options.com (and their
redirection)
The actual web page it might end up using is something like:
http://oic.ivolatil
If you bookmark that URL and try to visit it after the security cookie has
expired, it won't work at all. Try visiting that web page with the EXCEL
Web Query dialog and see if you see option quotes and volatility
information.
On Wed, Oct 30, 2013 at 12:19 PM, c1sander <craig.sander@
>
> I opened up the site from Excel and the formula (after forced
> recalculation) still gives an error. Is there something that might be
> preventing the creation of the cookie?
>
Wed Oct 30, 2013 6:00 pm (PDT) . Posted by:
"mpalmer@swbell.net" mpalmer@swbell.net
Unfortunately, I can't answer that because I don't know. Here is the function utilized the most on my spreadsheet - =RCHGetElementNumber(Ticker, 5899) where ticker is a named range holding the symbol. Can you direct me to documentation that would show what the actual URL points to?
--- In smf_addin@yahoogroups.com, Randy Harmelink <rharmelink@...> wrote:
>
> Did you old usage of AdvFN require use of a regional prefix?
>
> On Tue, Oct 29, 2013 at 7:20 PM, mpalmer@... <mpalmer@...>wrote:
>
> > Have a sheet full of data from ADVFN and used to pull the data using
> > RCHGetElement function. It quit working some time ago (getting "error"
> > msg). I downloaded the new add in xla but that hasn't worked either. I
> > can get a few of the functions to work on some of the elements but can't
> > seem to get anything working for the ADVFN site. Have tried the
> > smfGetAdvFNElement() function but no success ("error"). Any suggestions?
> > Using Excel 2007.
> >
>
--- In smf_addin@yahoogrou
>
> Did you old usage of AdvFN require use of a regional prefix?
>
> On Tue, Oct 29, 2013 at 7:20 PM, mpalmer@... <mpalmer@
>
> > Have a sheet full of data from ADVFN and used to pull the data using
> > RCHGetElement function. It quit working some time ago (getting "error"
> > msg). I downloaded the new add in xla but that hasn't worked either. I
> > can get a few of the functions to work on some of the elements but can't
> > seem to get anything working for the ADVFN site. Have tried the
> > smfGetAdvFNElement(
> > Using Excel 2007.
> >
>
Tidak ada komentar:
Posting Komentar