5 New Messages
Digest #2889
Messages
Mon Dec 9, 2013 5:25 am (PST) . Posted by:
mikemcq802
Just fyi I just reported a problem to GuruFocus for IBM related to CapEx. Hard to know how many other companies are affected.
IBM's own financials have a line item of "Investment in software" which AdvFN adds into PP&E (see page 58).
http://www.ibm.com/annualreport/2012/bin/assets/2012_ibm_financials.pdf
However, Guru doesn't add it in there nor does it list it separately so the amount is lost.
Guru also doesn't show IBM's value for "Non-operating finance receivables - net" but I don't use that value.
PS: Google includes the "Investment in software" in the CapEx number it shows while Yahoo does not - fun and joy.
IBM's own financials have a line item of "Investment in software" which AdvFN adds into PP&E (see page 58).
http://www.ibm.
However, Guru doesn't add it in there nor does it list it separately so the amount is lost.
Guru also doesn't show IBM's value for "Non-operating finance receivables - net" but I don't use that value.
PS: Google includes the "Investment in software" in the CapEx number it shows while Yahoo does not - fun and joy.
Mon Dec 9, 2013 1:31 pm (PST) . Posted by:
alexcomp1
It has been my experience that learning something new often presents a challenge in where to start. I want to do something very simple like load a last price quote into an Excel spreadsheet. Looked at your documentation - copied formulas exactly into Excel 2010 but nothing returns except the ticker.
Using Windows 8.1 could that be a problem?
I have a Yahoo account and seem to recall configuring it for real time once but it's fuzzy. Do I need to sign into Yahoo to get quotes? Is there another service I should use alternatively? Elite customer with Etrade - do they have an accessible server?
All I want is last price and the ability to periodically recompute. Feeling dumb here...
Using Windows 8.1 could that be a problem?
I have a Yahoo account and seem to recall configuring it for real time once but it's fuzzy. Do I need to sign into Yahoo to get quotes? Is there another service I should use alternatively? Elite customer with Etrade - do they have an accessible server?
All I want is last price and the ability to periodically recompute. Feeling dumb here...
Mon Dec 9, 2013 1:45 pm (PST) . Posted by:
"Randy Harmelink" rharmelink
To get back a price quote, you'd do something like:
=RCHGetYahooQuotes("MMM","l1")
Did you enter the function without the second parameter? If you just
entered:
=RCHGetYahooQuotes("MMM")
...you'll get just the ticker returned, because the default second
parameter is "sl1d1t1c1ohgv". That is a list of 9 items, where the first
item is the ticker symbol. To get all 9 items, you'd need to array-enter
the formula over a 1-row by 9-column range.
To update, you should use the smfForceRecalculation macro that is part of
the add-in. For more info on it, see the LINKS area of the group.
On Mon, Dec 9, 2013 at 2:31 PM, <sgg@alexcomp.com> wrote:
>
> It has been my experience that learning something new often presents a
> challenge in where to start. I want to do something very simple like load
> a last price quote into an Excel spreadsheet. Looked at your documentation
> - copied formulas exactly into Excel 2010 but nothing returns except the
> ticker.
>
> Using Windows 8.1 could that be a problem?
>
> I have a Yahoo account and seem to recall configuring it for real time
> once but it's fuzzy. Do I need to sign into Yahoo to get quotes? Is there
> another service I should use alternatively? Elite customer with Etrade -
> do they have an accessible server?
>
> All I want is last price and the ability to periodically recompute.
> Feeling dumb here...
>
>
=RCHGetYahooQuotes(
Did you enter the function without the second parameter? If you just
entered:
=RCHGetYahooQuotes(
...you'll get just the ticker returned, because the default second
parameter is "sl1d1t1c1ohgv
item is the ticker symbol. To get all 9 items, you'd need to array-enter
the formula over a 1-row by 9-column range.
To update, you should use the smfForceRecalculati
the add-in. For more info on it, see the LINKS area of the group.
On Mon, Dec 9, 2013 at 2:31 PM, <sgg@alexcomp.
>
> It has been my experience that learning something new often presents a
> challenge in where to start. I want to do something very simple like load
> a last price quote into an Excel spreadsheet. Looked at your documentation
> - copied formulas exactly into Excel 2010 but nothing returns except the
> ticker.
>
> Using Windows 8.1 could that be a problem?
>
> I have a Yahoo account and seem to recall configuring it for real time
> once but it's fuzzy. Do I need to sign into Yahoo to get quotes? Is there
> another service I should use alternatively? Elite customer with Etrade -
> do they have an accessible server?
>
> All I want is last price and the ability to periodically recompute.
> Feeling dumb here...
>
>
Mon Dec 9, 2013 7:02 pm (PST) . Posted by:
team1688
Dear Randy;
How can I get RCHGetYahooQuotes return value it seem to be display only and I put in array of formula to get yahoo quotes. I need the value to compare, not just display. Back several months back I found some a file "standalone' yahoo quote, and a note also said the vaulue can be use for other purpose not display. I remember I download that file but I since lost it. Can you help me?
Warren
How can I get RCHGetYahooQuotes return value it seem to be display only and I put in array of formula to get yahoo quotes. I need the value to compare, not just display. Back several months back I found some a file "standalone&#
Warren
Mon Dec 9, 2013 9:32 pm (PST) . Posted by:
"Randy Harmelink" rharmelink
Standalone workbook examples are in the SMFLite subfolder of the Examples
folder.
Otherwise, I'm not quite sure what you're asking. If you need values for
comparison, you'll have to convert the formulas to values yourself?
On Mon, Dec 9, 2013 at 8:02 PM, <team1688@yahoo.com> wrote:
>
> How can I get RCHGetYahooQuotes return value it seem to be display only
> and I put in array of formula to get yahoo quotes. I need the value to
> compare, not just display. Back several months back I found some a file
> "standalone' yahoo quote, and a note also said the vaulue can be use for
> other purpose not display. I remember I download that file but I since
> lost it. Can you help me?
>
folder.
Otherwise, I'm not quite sure what you're asking. If you need values for
comparison, you'll have to convert the formulas to values yourself?
On Mon, Dec 9, 2013 at 8:02 PM, <team1688@yahoo.
>
> How can I get RCHGetYahooQuotes return value it seem to be display only
> and I put in array of formula to get yahoo quotes. I need the value to
> compare, not just display. Back several months back I found some a file
> "standalone&#
> other purpose not display. I remember I download that file but I since
> lost it. Can you help me?
>
Tidak ada komentar:
Posting Komentar