10 New Messages
Digest #2282
Messages
Tue Jul 17, 2012 11:30 am (PDT) . Posted by:
"Ron" rlcarr71
I was using the SMF-Template-Earnings.com-Data.xls template and noticed strange results on the Dividend History.
I enter in the ticker CAT (Caterpillar, NYSE).
However, in the dividend history it shows the dividends for
CAT (NYSE)
CAT.BA (Buenos Aires)
CATER.BR (Brussels)
Is there anyway to get just CAT (NYSE)?
I enter in the ticker CAT (Caterpillar, NYSE).
However, in the dividend history it shows the dividends for
CAT (NYSE)
CAT.BA (Buenos Aires)
CATER.BR (Brussels)
Is there anyway to get just CAT (NYSE)?
Tue Jul 17, 2012 11:57 am (PDT) . Posted by:
"Randy Harmelink" rharmelink
The template just dumps whatever earnings.com has out there. So if a
company has multiple issues and you only want one, you'd need to do your
own extraction of data from the page.
I really should have kept ticker symbols as well, except that I didn't know
it could have multiple ticker symbols at the time I created the element
numbers.
In retrospect, I probably shouldn't have created those element numbers at
all, but created a template with a cascading extraction.
On Tue, Jul 17, 2012 at 11:30 AM, Ron <rlcarr71@yahoo.com > wrote:
> I was using the SMF-Template-Earnings.com-Data.xls template and noticed
> strange results on the Dividend History.
>
> I enter in the ticker CAT (Caterpillar, NYSE).
>
> However, in the dividend history it shows the dividends for
> CAT (NYSE)
> CAT.BA (Buenos Aires)
> CATER.BR (Brussels)
>
> Is there anyway to get just CAT (NYSE)?
>
company has multiple issues and you only want one, you'd need to do your
own extraction of data from the page.
I really should have kept ticker symbols as well, except that I didn't know
it could have multiple ticker symbols at the time I created the element
numbers.
In retrospect, I probably shouldn't have created those element numbers at
all, but created a template with a cascading extraction.
On Tue, Jul 17, 2012 at 11:30 AM, Ron <rlcarr71@yahoo.
> I was using the SMF-Template-
> strange results on the Dividend History.
>
> I enter in the ticker CAT (Caterpillar, NYSE).
>
> However, in the dividend history it shows the dividends for
> CAT (NYSE)
> CAT.BA (Buenos Aires)
> CATER.BR (Brussels)
>
> Is there anyway to get just CAT (NYSE)?
>
Tue Jul 17, 2012 11:59 am (PDT) . Posted by:
"Ron Spruell" hashky
I always have to correct the links in downloaded workbooks. I have RCH_Stock_Market_Functions.xla. Status: Source is Open. The equations look correct. No extra long location length.
Do I need to be logged in at the Website?
>________________________________
> From: Randy Harmelink <rharmelink@gmail.com >
>To: smf_addin@yahoogroups.com
>Sent: Monday, July 16, 2012 11:19 PM
>Subject: Re: [smf_addin] Re: Updates in Your Groups, July 11, 2012
>
>
>
>Did you fix the location errors (see LINKS area of group)?
>
>
>On Mon, Jul 16, 2012 at 5:56 PM, Ron Spruell <hashky@yahoo.com > wrote:
>
>
>>
>>
>>
>>I can't seem to get this to work. No errors, no nothing. SMFForceRecalculation runs instantly, with no output. Got any ideas what I might be doing wrong?
>>
>>
>>Windows XP
>>
>>Stock Market Functions add-in, Version 2.1.2012.07.12 (C:\Program Files\SMF Add-In; 1)
>>
>
>
>
>
Do I need to be logged in at the Website?
>___________
> From: Randy Harmelink <rharmelink@gmail.
>To: smf_addin@yahoogrou
>Sent: Monday, July 16, 2012 11:19 PM
>Subject: Re: [smf_addin] Re: Updates in Your Groups, July 11, 2012
>
>
>
>Did you fix the location errors (see LINKS area of group)?
>
>
>On Mon, Jul 16, 2012 at 5:56 PM, Ron Spruell <hashky@yahoo.
>
>
>>
>>
>>
>>I can't seem to get this to work. No errors, no nothing. SMFForceRecalculati
>>
>>
>>Windows XP
>>
>>Stock Market Functions add-in, Version 2.1.2012.07.
>>
>
>
>
>
Tue Jul 17, 2012 12:03 pm (PDT) . Posted by:
"Randy Harmelink" rharmelink
I don't think you have to be logged in, but there may be a disclaimer on
your first visit that you need to fill out before the data is available.
What formula do you see in cell C5 of the workbook?
Try visiting the URL with the EXCEL Web Query dialog and see if you can see
the data on the web page...
On Tue, Jul 17, 2012 at 11:59 AM, Ron Spruell <hashky@yahoo.com > wrote:
>
> I always have to correct the links in downloaded workbooks. I have
> RCH_Stock_Market_Functions.xla. Status: Source is Open. The equations
> look correct. No extra long location length.
>
> Do I need to be logged in at the Website?
>
your first visit that you need to fill out before the data is available.
What formula do you see in cell C5 of the workbook?
Try visiting the URL with the EXCEL Web Query dialog and see if you can see
the data on the web page...
On Tue, Jul 17, 2012 at 11:59 AM, Ron Spruell <hashky@yahoo.
>
> I always have to correct the links in downloaded workbooks. I have
> RCH_Stock_Market_
> look correct. No extra long location length.
>
> Do I need to be logged in at the Website?
>
Tue Jul 17, 2012 1:07 pm (PDT) . Posted by:
"Ron Spruell" hashky
Cell C4:
=IF(C4="--","--",smfGetTagContent("http://dividata.com/dividates ","a",-2,">"&C4&"<",G4,"rating_bar_"&$C$2,"rating_bar_"&$C$2,,"--"))
This Cell is definitely the problem. I can enter a 5 in Cell C2, and PG in Cell C5. All the 5 rated stocks are returned after PG.
Ditto for 3 and 4 in C2. The equation in C5 does not appear to find the first Ticker.
>________________________________
> From: Randy Harmelink <rharmelink@gmail.com >
>To: smf_addin@yahoogroups.com
>Sent: Tuesday, July 17, 2012 2:03 PM
>Subject: Re: [smf_addin] Re: Updates in Your Groups, July 11, 2012
>
>
>
>I don't think you have to be logged in, but there may be a disclaimer on your first visit that you need to fill out before the data is available. What formula do you see in cell C5 of the workbook?
>
>Try visiting the URL with the EXCEL Web Query dialog and see if you can see the data on the web page...
>
>
>On Tue, Jul 17, 2012 at 11:59 AM, Ron Spruell <hashky@yahoo.com > wrote:
>
>
>>
>>I always have to correct the links in downloaded workbooks. I have RCH_Stock_Market_Functions.xla. Status: Source is Open. The equations look correct. No extra long location length.
>>
>>
>>Do I need to be logged in at the Website?
>>
>
>
>
>
=IF(C4="--",
This Cell is definitely the problem. I can enter a 5 in Cell C2, and PG in Cell C5. All the 5 rated stocks are returned after PG.
Ditto for 3 and 4 in C2. The equation in C5 does not appear to find the first Ticker.
>___________
> From: Randy Harmelink <rharmelink@gmail.
>To: smf_addin@yahoogrou
>Sent: Tuesday, July 17, 2012 2:03 PM
>Subject: Re: [smf_addin] Re: Updates in Your Groups, July 11, 2012
>
>
>
>I don't think you have to be logged in, but there may be a disclaimer on your first visit that you need to fill out before the data is available. What formula do you see in cell C5 of the workbook?
>
>Try visiting the URL with the EXCEL Web Query dialog and see if you can see the data on the web page...
>
>
>On Tue, Jul 17, 2012 at 11:59 AM, Ron Spruell <hashky@yahoo.
>
>
>>
>>I always have to correct the links in downloaded workbooks. I have RCH_Stock_Market_
>>
>>
>>Do I need to be logged in at the Website?
>>
>
>
>
>
Tue Jul 17, 2012 1:31 pm (PDT) . Posted by:
"Randy Harmelink" rharmelink
Cell C4 should be a column header of "Ticker".
Cell C5 should be: =smfGetTagContent("http://dividata.com/dividates
","a",-2,"rating_bar_"&$C$2,,,,,"--")
Your formula below has a cascading search in it (i.e. the ">"&C4&"<" search
string). The first ticker cell should NOT be a cascading one.
Are you sure you have the current file from the FILES area? I'm opening the
file from there when I'm checking out your replies.
On Tue, Jul 17, 2012 at 1:07 PM, Ron Spruell <hashky@yahoo.com > wrote:
>
> Cell C4:
>
> =IF(C4="--","--",smfGetTagContent("http://dividata.com/dividates
> ","a",-2,">"&C4&"<",G4,"rating_bar_"&$C$2,"rating_bar_"&$C$2,,"--"))
>
> This Cell is definitely the problem. I can enter a 5 in Cell C2, and PG
> in Cell C5. All the 5 rated stocks are returned after PG.
> Ditto for 3 and 4 in C2. The equation in C5 does not appear to find the
> first Ticker.
>
Cell C5 should be: =smfGetTagContent(
","a",-2,"rating_
Your formula below has a cascading search in it (i.e. the ">"&C4&"<" search
string). The first ticker cell should NOT be a cascading one.
Are you sure you have the current file from the FILES area? I'm opening the
file from there when I'm checking out your replies.
On Tue, Jul 17, 2012 at 1:07 PM, Ron Spruell <hashky@yahoo.
>
> Cell C4:
>
> =IF(C4="--",
> ","a",-2,">"
>
> This Cell is definitely the problem. I can enter a 5 in Cell C2, and PG
> in Cell C5. All the 5 rated stocks are returned after PG.
> Ditto for 3 and 4 in C2. The equation in C5 does not appear to find the
> first Ticker.
>
Tue Jul 17, 2012 3:04 pm (PDT) . Posted by:
"Ron Spruell" hashky
I downloaded again. It works. Thanks.
>________________________________
> From: Randy Harmelink <rharmelink@gmail.com >
>To: smf_addin@yahoogroups.com
>Sent: Tuesday, July 17, 2012 3:31 PM
>Subject: Re: [smf_addin] Re: Updates in Your Groups, July 11, 2012
>
>
>
>Cell C4 should be a column header of "Ticker".
>
>Cell C5 should be: =smfGetTagContent("http://dividata.com/dividates ","a",-2,"rating_bar_"&$C$2,,,,,"--")
>
>Your formula below has a cascading search in it (i.e. the ">"&C4&"<" search string). The first ticker cell should NOT be a cascading one.
>
>Are you sure you have the current file from the FILES area? I'm opening the file from there when I'm checking out your replies.
>
>
>On Tue, Jul 17, 2012 at 1:07 PM, Ron Spruell <hashky@yahoo.com > wrote:
>
>
>>
>>Cell C4:
>>
>>
>>=IF(C4="--","--",smfGetTagContent("http://dividata.com/dividates ","a",-2,">"&C4&"<",G4,"rating_bar_"&$C$2,"rating_bar_"&$C$2,,"--"))
>>
>>
>>This Cell is definitely the problem. I can enter a 5 in Cell C2, and PG in Cell C5. All the 5 rated stocks are returned after PG.
>>Ditto for 3 and 4 in C2. The equation in C5 does not appear to find the first Ticker.
>>
>
>
>
>
>___________
> From: Randy Harmelink <rharmelink@gmail.
>To: smf_addin@yahoogrou
>Sent: Tuesday, July 17, 2012 3:31 PM
>Subject: Re: [smf_addin] Re: Updates in Your Groups, July 11, 2012
>
>
>
>Cell C4 should be a column header of "Ticker".
>
>Cell C5 should be: =smfGetTagContent(
>
>Your formula below has a cascading search in it (i.e. the ">"&C4&"<" search string). The first ticker cell should NOT be a cascading one.
>
>Are you sure you have the current file from the FILES area? I'm opening the file from there when I'm checking out your replies.
>
>
>On Tue, Jul 17, 2012 at 1:07 PM, Ron Spruell <hashky@yahoo.
>
>
>>
>>Cell C4:
>>
>>
>>=IF(C4="--
>>
>>
>>This Cell is definitely the problem. I can enter a 5 in Cell C2, and PG in Cell C5. All the 5 rated stocks are returned after PG.
>>Ditto for 3 and 4 in C2. The equation in C5 does not appear to find the first Ticker.
>>
>
>
>
>
Tue Jul 17, 2012 2:48 pm (PDT) . Posted by:
"invesco88" invesco88
Quick question. Does any one know how to use the create comment function to display the text of the company description? In a comp sheet they take up too much space. I was thinking I could import the description then copy / paste a linked picture and then point the create comment function to that picture but it's not displaying the text. Any help would be great. Thanks.
Tue Jul 17, 2012 4:38 pm (PDT) . Posted by:
"Randy Harmelink" rharmelink
Try something like:
http://finance.groups.yahoo.com/group/smf_addin/message/11149
On Tue, Jul 17, 2012 at 2:48 PM, invesco88 <franklin.forward@gmail.com >wrote:
> Quick question. Does any one know how to use the create comment function
> to display the text of the company description? In a comp sheet they take
> up too much space. I was thinking I could import the description then copy
> / paste a linked picture and then point the create comment function to that
> picture but it's not displaying the text. Any help would be great. Thanks.
>
http://finance.
On Tue, Jul 17, 2012 at 2:48 PM, invesco88 <franklin.forward@
> Quick question. Does any one know how to use the create comment function
> to display the text of the company description? In a comp sheet they take
> up too much space. I was thinking I could import the description then copy
> / paste a linked picture and then point the create comment function to that
> picture but it's not displaying the text. Any help would be great. Thanks.
>
Tue Jul 17, 2012 8:19 pm (PDT) . Posted by:
"bomindus" bomindus
I have Excel 2007 and I downloaded the MSN Money Add-in and I'm using it currently, but one thing that I found is that I can't input the Forward PE ratio because there is no option for it in the MSN Money Add-in. Is there any advice or help anyone has for me?
Tidak ada komentar:
Posting Komentar