9 Messages
Digest #3137
Messages
Thu Jul 31, 2014 3:47 am (PDT) . Posted by:
bushpilote
Try the function proposed by Microsoft: http://support.microsoft.com/kb/245104
Thu Jul 31, 2014 10:18 am (PDT) . Posted by:
DefelRadar
Randy, I am using RCHGetElementNumber(XXX,641) to give me the Actual Earnings for a stock for the previous year. I use this in tandem with a macro I made to go out to yahoo and get the earnings calendar for stocks that are scheduled to release earnings on a date I provide (08/05/14, 08/06/14, 08/07/14 etc.) What I've found is if I go more than a week ahead with the earnings calendar I download all the symbols that are to release earnings on 08/07/14 for instance but RCHGetElementNumber(XXX,641) will not return the actual earnings for the stock in question. It only comes back Error.
For example Wendy's (WEN) is going to release earnings on 8/7/14. If I do RCHGetElementNumber("WEN",641) it returns an error
Same thing for Balchem (BCPC) RCHGetElementNumber(BCPC,641) that going to release earnings on 8/8/14.
But if I pick a stock that reports on 8/6/14 or earlier DVN for instance it returns a quarterly earnings value for that stock.
I can't think of any reason the function would do this and was hoping you would have an answer or alternative I could use.
Thanks,
Aaron
For example Wendy's (WEN) is going to release earnings on 8/7/14. If I do RCHGetElementNumber
Same thing for Balchem (BCPC) RCHGetElementNumber
But if I pick a stock that reports on 8/6/14 or earlier DVN for instance it returns a quarterly earnings value for that stock.
I can't think of any reason the function would do this and was hoping you would have an answer or alternative I could use.
Thanks,
Aaron
Thu Jul 31, 2014 10:32 am (PDT) . Posted by:
"Randy Harmelink" rharmelink
I'm not seeing what you're talking about. Both of these work fine for me:
=RCHGetElementNumber("WEN",641)
=RCHGetElementNumber("BCPC",641)
...returning the $0.08 and $0.38 I see on the Yahoo Earnings Estimate web
page.
What does your definition of element #641 look like? That is:
=smfGetAParms(641)
On Thu, Jul 31, 2014 at 10:18 AM, defelradar@yahoo.com [smf_addin] <
smf_addin@yahoogroups.com> wrote:
> Randy, I am using RCHGetElementNumber(XXX,641) to give me the Actual
> Earnings for a stock for the previous year. I use this in tandem with a
> macro I made to go out to yahoo and get the earnings calendar for stocks
> that are scheduled to release earnings on a date I provide (08/05/14,
> 08/06/14, 08/07/14 etc.) What I've found is if I go more than a week ahead
> with the earnings calendar I download all the symbols that are to release
> earnings on 08/07/14 for instance but RCHGetElementNumber(XXX,641) will not
> return the actual earnings for the stock in question. It only comes back
> Error.
>
> For example Wendy's (WEN) is going to release earnings on 8/7/14. If I do
> RCHGetElementNumber("WEN",641) it returns an error
>
> Same thing for Balchem (BCPC) RCHGetElementNumber(BCPC,641) that going to
> release earnings on 8/8/14.
>
> But if I pick a stock that reports on 8/6/14 or earlier DVN for instance
> it returns a quarterly earnings value for that stock.
>
> I can't think of any reason the function would do this and was hoping you
> would have an answer or alternative I could use.
>
=RCHGetElementNumber("WEN",641)
=RCHGetElementNumber("BCPC",641)
...returning the $0.08 and $0.38 I see on the Yahoo Earnings Estimate web
page.
What does your definition of element #641 look like? That is:
=smfGetAParms(641)
On Thu, Jul 31, 2014 at 10:18 AM, defelradar@yahoo.com [smf_addin] <
smf_addin@yahoogroups.com> wrote:
> Randy, I am using RCHGetElementNumber
> Earnings for a stock for the previous year. I use this in tandem with a
> macro I made to go out to yahoo and get the earnings calendar for stocks
> that are scheduled to release earnings on a date I provide (08/05/14,
> 08/06/14, 08/07/14 etc.) What I've found is if I go more than a week ahead
> with the earnings calendar I download all the symbols that are to release
> earnings on 08/07/14 for instance but RCHGetElementNumber
> return the actual earnings for the stock in question. It only comes back
> Error.
>
> For example Wendy's (WEN) is going to release earnings on 8/7/14. If I do
> RCHGetElementNumber
>
> Same thing for Balchem (BCPC) RCHGetElementNumber
> release earnings on 8/8/14.
>
> But if I pick a stock that reports on 8/6/14 or earlier DVN for instance
> it returns a quarterly earnings value for that stock.
>
> I can't think of any reason the function would do this and was hoping you
> would have an answer or alternative I could use.
>
Thu Jul 31, 2014 11:07 am (PDT) . Posted by:
DefelRadar
I'm not quite sure what you mean by definition but the way I am using it is as follows:
=RCHGetElementNumber(B9,641) where B9 is the cell that contains the stock symbol.
The ways I have tried it is the above and =RCHGetElementNumber("WEN";,641) and both returns Error.
Thanks,
Aaron
=RCHGetElementNumbe
The ways I have tried it is the above and =RCHGetElementNumbe
Thanks,
Aaron
Thu Jul 31, 2014 11:11 am (PDT) . Posted by:
DefelRadar
Sorry I figured out what you meant
641;YahooAE;Earnings Surprise -- EPS Actual -- FQ1;http://finance.yahoo.com/q/ae?s=~~~~~;1;EARNINGS HISTORY;EPS ACTUAL; ; ;0;0;0;0
is the definition
641;YahooAE;Earnings Surprise -- EPS Actual -- FQ1;http://finance.yahoo.com/q/ae?s=~~~~~;1;EARNINGS HISTORY;EPS ACTUAL; ; ;0;0;0;0
is the definition
Thu Jul 31, 2014 11:15 am (PDT) . Posted by:
"Randy Harmelink" rharmelink
Try running the smfForceRecalculation macro (see Tips and FAQs page for
more info on it) and see if you get a different result. Yahoo may have
returned a bad web page for you earlier.
The other function I gave you:
=smfGetAParms(641)
...returns the definition of element #641.
On Thu, Jul 31, 2014 at 11:07 AM, defelradar@... wrote:
> I'm not quite sure what you mean by definition but the way I am using it
> is as follows:
>
> =RCHGetElementNumber(B9,641) where B9 is the cell that contains the stock
> symbol.
>
> The ways I have tried it is the above and =RCHGetElementNumber("WEN";,641)
> and both returns Error.
>
more info on it) and see if you get a different result. Yahoo may have
returned a bad web page for you earlier.
The other function I gave you:
=smfGetAParms(
...returns the definition of element #641.
On Thu, Jul 31, 2014 at 11:07 AM, defelradar@.
> I'm not quite sure what you mean by definition but the way I am using it
> is as follows:
>
> =RCHGetElementNumbe
> symbol.
>
> The ways I have tried it is the above and =RCHGetElementNumbe
> and both returns Error.
>
Thu Jul 31, 2014 11:16 am (PDT) . Posted by:
"Randy Harmelink" rharmelink
That's the correct definition. So hopefully you had a glitch from Yahoo.
On Thu, Jul 31, 2014 at 11:11 AM, defelradar@... wrote:
> Sorry I figured out what you meant
>
> 641;YahooAE;Earnings Surprise -- EPS Actual -- FQ1;
> http://finance.yahoo.com/q/ae?s=~~~~~;1;EARNINGS HISTORY;EPS ACTUAL; ;
> ;0;0;0;0
> is the definition
>
On Thu, Jul 31, 2014 at 11:11 AM, defelradar@... wrote:
> Sorry I figured out what you meant
>
> 641;YahooAE;Earnings Surprise -- EPS Actual -- FQ1;
> http://finance.yahoo.com/q/ae?s=~~~~~;1;EARNINGS HISTORY;EPS ACTUAL; ;
> ;0;0;0;0
> is the definition
>
Thu Jul 31, 2014 11:32 am (PDT) . Posted by:
DefelRadar
Well....I'll keep track of it and see if how repeatable it is. I know it's happened several times to me in the past but I'll focus on seeing over the next few days how repeatable it is. Thanks for your help!
Aaron
Aaron
Thu Jul 31, 2014 11:39 am (PDT) . Posted by:
DefelRadar
Randy I ran the recalc macro you suggested and it cleared things up. Guess I might have to do that from time to time.
Thanks,
Aaron
Thanks,
Aaron
For the Add-in, Documentation, Templates, Tips and FAQs, visit http://ogres-crypt.com/SMF
Tidak ada komentar:
Posting Komentar