5 New Messages
Digest #2833
Messages
Wed Oct 30, 2013 6:44 pm (PDT) . Posted by:
"mpalmer@swbell.net" mpalmer@swbell.net
Randy,
Please disregard. I uninstalled the old xla and removed the folder then reinstalled everything and it appears to work fine. Thanks for all of your efforts on developing these helpful UDFs.
mark
--- In smf_addin@yahoogroups.com, "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.
>
Please disregard. I uninstalled the old xla and removed the folder then reinstalled everything and it appears to work fine. Thanks for all of your efforts on developing these helpful UDFs.
mark
--- In smf_addin@yahoogrou
>
> 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(
>
Wed Oct 30, 2013 8:13 pm (PDT) . Posted by:
dcharlotte99
I'm having same problem. Missing Total Equity and Total Shares Outstanding among a handful of others. I'm using the Gurufocus model from the Forum, which has a slightly different formula convention than above and I can't see why it doesn't work. It's been a very frustrating few months, I switched from ADVFn and recreated my equations for the Gurufocus model and now this happens.
---In smf_addin@yahoogroups.com, <rharmelink@...> wrote:
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/ http://www.gurufocus.com/financials/"&C7,11,">Fiscal Period",">Balance Sheet",">Total Equity")
=RCHGetTableCell("http://www.gurufocus.com/financials/ http://www.gurufocus.com/financials/"&C5,11,">Fiscal Period","/Total Equity/")
=RCHGetTableCell("http://www.gurufocus.com/financials/ http://www.gurufocus.com/financials/"&C4,11,">Fiscal Period",">Total Equity<")
=RCHGetTableCell("http://www.gurufocus.com/financials/ 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@... mailto:amt2100@...> 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.
---In smf_addin@yahoogrou
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@
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 8:51 pm (PDT) . Posted by:
hamishthedenizen
GuruFocus have added a whole raft of detail to their 10 year financials - particularly Balance Sheet and Cash Flow information that was missing before. They also changed the spelling of certain items, so the sheet doesn't work now.
I have a crude version of the sheet using the new data but I am buried under other duties at the moment. I'll try to post a fixed version of the sheet ASAP, but it's probably going to be a few days.
---In smf_addin@yahoogroups.com, <dcharlotte99@...> wrote:
I'm having same problem. Missing Total Equity and Total Shares Outstanding among a handful of others. I'm using the Gurufocus model from the Forum, which has a slightly different formula convention than above and I can't see why it doesn't work. It's been a very frustrating few months, I switched from ADVFn and recreated my equations for the Gurufocus model and now this happens.
---In smf_addin@yahoogroups.com, <rharmelink@...> wrote:
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/ http://www.gurufocus.com/financials/"&C7,11,">Fiscal Period",">Balance Sheet",">Total Equity")
=RCHGetTableCell("http://www.gurufocus.com/financials/ http://www.gurufocus.com/financials/"&C5,11,">Fiscal Period","/Total Equity/")
=RCHGetTableCell("http://www.gurufocus.com/financials/ http://www.gurufocus.com/financials/"&C4,11,">Fiscal Period",">Total Equity<")
=RCHGetTableCell("http://www.gurufocus.com/financials/ 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@... mailto:amt2100@...> 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.
I have a crude version of the sheet using the new data but I am buried under other duties at the moment. I'll try to post a fixed version of the sheet ASAP, but it's probably going to be a few days.
---In smf_addin@yahoogrou
I'm having same problem. Missing Total Equity and Total Shares Outstanding among a handful of others. I'm using the Gurufocus model from the Forum, which has a slightly different formula convention than above and I can't see why it doesn't work. It's been a very frustrating few months, I switched from ADVFn and recreated my equations for the Gurufocus model and now this happens.
---In smf_addin@yahoogrou
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@
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 9:22 pm (PDT) . Posted by:
hamishthedenizen
GuruFocus changed their format. I've uploaded a new version of the sheet that hopefully deals with the issues. Please try it and flag any problems with it.
---In smf_addin@yahoogroups.com, <dcharlotte99@...> wrote:
I'm having same problem. Missing Total Equity and Total Shares Outstanding among a handful of others. I'm using the Gurufocus model from the Forum, which has a slightly different formula convention than above and I can't see why it doesn't work. It's been a very frustrating few months, I switched from ADVFn and recreated my equations for the Gurufocus model and now this happens.
---In smf_addin@yahoogroups.com, <rharmelink@...> wrote:
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/ http://www.gurufocus.com/financials/"&C7,11,">Fiscal Period",">Balance Sheet",">Total Equity")
=RCHGetTableCell("http://www.gurufocus.com/financials/ http://www.gurufocus.com/financials/"&C5,11,">Fiscal Period","/Total Equity/")
=RCHGetTableCell("http://www.gurufocus.com/financials/ http://www.gurufocus.com/financials/"&C4,11,">Fiscal Period",">Total Equity<")
=RCHGetTableCell("http://www.gurufocus.com/financials/ 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@... mailto:amt2100@...> 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.
---In smf_addin@yahoogrou
I'm having same problem. Missing Total Equity and Total Shares Outstanding among a handful of others. I'm using the Gurufocus model from the Forum, which has a slightly different formula convention than above and I can't see why it doesn't work. It's been a very frustrating few months, I switched from ADVFn and recreated my equations for the Gurufocus model and now this happens.
---In smf_addin@yahoogrou
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@
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 9:23 pm (PDT) . Posted by:
hamishthedenizen
I found out about the issues with the model. GuruFocus added a lot of new 10 year data - especially in the Balance Sheet and Cash Flow sections, and changed a lot of the names of the various line items. As a result the old model stopped working.
I've uploaded a new version. It's a quick-n-dirty piece of work, and seems to work fine, but I have not had the time to check it thoroughly, so any feedback would be appreciated and I'll fix it as best I can.
I've uploaded a new version. It's a quick-n-dirty piece of work, and seems to work fine, but I have not had the time to check it thoroughly, so any feedback would be appreciated and I'll fix it as best I can.
Tidak ada komentar:
Posting Komentar