Messages In This Digest (4 Messages)
- 1a.
- download/update the earings release date From: wongchun72
- 1b.
- Re: download/update the earings release date From: Randy Harmelink
- 2a.
- Excel 2011 problem From: herb.baldwin
- 2b.
- Re: Excel 2011 problem From: Randy Harmelink
Messages
- 1a.
-
download/update the earings release date
Posted by: "wongchun72" wangchuncn@hotmail.com wongchun72
Sun Aug 21, 2011 10:49 am (PDT)
Hi,
Does someone know whether there is an Excel add-in to download/update the earings release date for a selected stock symbol? Just as we can download the day-close-price for a selected stock symbol.
On Yahoo earnings calendar, we can find the companies that are going to release or have rleased their results in the recent period. This is calenard-day driven.
We can also find on each individual stock page, the release date for that company. This is company-name-drive, but we need to go web-page by web-page to manually collect the info.
If we want to easily get an overview of the stocks on our radar-screen that are going to rlease their financial result, is there any software tool helping us to do so?
Thanks!
- 1b.
-
Re: download/update the earings release date
Posted by: "Randy Harmelink" rharmelink@gmail.com rharmelink
Sun Aug 21, 2011 11:05 am (PDT)
Do a search of the message archives and you'll find a number of discussions
on the topic. At this point, I would suggest either Zacks or FinViz, since
they allow grabbing the data by individual ticker symbol or a group of
ticker symbols.
Check out the "Links" area of the group for getting data via the FinViz
screener.
On Sat, Aug 20, 2011 at 1:51 AM, wongchun72 <wangchuncn@hotmail.com > wrote:
>
> Does someone know whether there is an Excel add-in to download/update the
> earings release date for a selected stock symbol? Just as we can download
> the day-close-price for a selected stock symbol.
>
> On Yahoo earnings calendar, we can find the companies that are going to
> release or have rleased their results in the recent period. This is
> calenard-day driven.
>
> We can also find on each individual stock page, the release date for that
> company. This is company-name-drive, but we need to go web-page by web-page
> to manually collect the info.
>
> If we want to easily get an overview of the stocks on our radar-screen that
> are going to rlease their financial result, is there any software tool
> helping us to do so?
>
- 2a.
-
Excel 2011 problem
Posted by: "herb.baldwin" herb.baldwin@yahoo.com herb.baldwin
Sun Aug 21, 2011 8:50 pm (PDT)
Here is what works at the present:
One special user (let's call him RCH Admin) has the addin installed. He is using Outlook2007. He opens the excel file containing the cells with RCH entries. The file is in a network share. He allows all cells to update. This can take 15 to 20 minutes because of the number of cells and the variety of data retrieved. He then saves the excel file in its original location.
Other users also running Excel 2007 but who do not have the addin installed, open the saved file and see all the data that was saved by the RCH Admin. Of course the data is static because they don't have the addin.
When we use Excell 2010 to open the file it places value errors in all of the cells as if it were trying to execute the RCH lookup and failing. Installing the add in has no effect.
Should this scenario work with Excel 2010 or is there something else I should do?
Regards, Herb
- 2b.
-
Re: Excel 2011 problem
Posted by: "Randy Harmelink" rharmelink@gmail.com rharmelink
Sun Aug 21, 2011 9:03 pm (PDT)
Not having the add-in installed should generate #NAME! errors, not #VALUE!
errors. But #VALUE! errors can occur if the add-in functions are being used
in a calculation, and the functions are returning something like "Error".
Outlook 2007 is irrelevant. Where the EXCEL file is saved is irrelevant.
I only have EXCEL 2007, so can't speak to EXCEL 2010 or EXCEL 2011
behaviors.
On Sun, Aug 21, 2011 at 8:45 PM, herb.baldwin <herb.baldwin@yahoo.com >wrote:
> Here is what works at the present:
>
> One special user (let's call him RCH Admin) has the addin installed. He is
> using Outlook2007. He opens the excel file containing the cells with RCH
> entries. The file is in a network share. He allows all cells to update. This
> can take 15 to 20 minutes because of the number of cells and the variety of
> data retrieved. He then saves the excel file in its original location.
>
> Other users also running Excel 2007 but who do not have the addin
> installed, open the saved file and see all the data that was saved by the
> RCH Admin. Of course the data is static because they don't have the addin.
>
> When we use Excell 2010 to open the file it places value errors in all of
> the cells as if it were trying to execute the RCH lookup and failing.
> Installing the add in has no effect.
>
> Should this scenario work with Excel 2010 or is there something else I
> should do?
>
Need to Reply?
Click one of the "Reply" links to respond to a specific message in the Daily Digest.
Change settings via the Web (Yahoo! ID required)
Change settings via email: Switch delivery to Individual | Switch format to Traditional
Visit Your Group | Yahoo! Groups Terms of Use | Unsubscribe
Tidak ada komentar:
Posting Komentar