Minggu, 02 Desember 2012

[smf_addin] Digest Number 2420

15 New Messages

Digest #2420
1b
Re: ta25 (maof) - israeli market index by "Randy Harmelink" rharmelink
2a
Re: 1000 Input Tickers Worksheet by "Kermit W. Prather" kermitpra
6.1
New file uploaded to smf_addin by "smf_addin@yahoogroups.com"

Messages

Sun Dec 2, 2012 4:05 am (PST) . Posted by:

"y" youval_marks

hi,

this index used to be available... but it's data seems to end last year!
please advise about how to get this on yahoo-finance...

PS - also can't seem to find it on google finance!

Sun Dec 2, 2012 4:25 am (PST) . Posted by:

"Randy Harmelink" rharmelink

No idea, other than using their "Contact Us" type links, and asking.

On Sun, Dec 2, 2012 at 5:05 AM, y <youval_marks@yahoo.co.uk> wrote:

>
> this index used to be available... but it's data seems to end last year!
> please advise about how to get this on yahoo-finance...
>
> PS - also can't seem to find it on google finance!
>

Sun Dec 2, 2012 7:03 am (PST) . Posted by:

"Kermit W. Prather" kermitpra

Yep, it makes sense.

Thanks, for the explanation.

-----Original Message-----
From: smf_addin@yahoogroups.com [mailto:smf_addin@yahoogroups.com] On Behalf
Of Andy
Sent: Friday, November 30, 2012 9:40 AM
To: smf_addin@yahoogroups.com
Subject: [smf_addin] Re: 1000 Input Tickers Worksheet

I don't use all 1000. In fact, I only use 100. I simply like the clean
format and speed of this template.

Further, I am not screening anything. I am tracking my watch list. I like
tracking it in a spreadsheet rather than online because of the increased
flexibility - hence my questions below.

I hope that helps, Kermit.

--- In smf_addin@yahoogroups.com, "Kermit W. Prather" <kermitp@...> wrote:
>
> Why in the world does anyone need 1000 stocks in a worksheet? Please
> help me understand why?
>
> Where is this spreadsheet? I'd like to see what it is all about? I'm
> curious now.
>
> There are numerous stock screeners, many FREE, to help narrow your
> list to a manageable list.
>
> -----Original Message-----
> From: smf_addin@yahoogroups.com [mailto:smf_addin@yahoogroups.com] On
> Behalf Of Andy
> Sent: Thursday, November 29, 2012 5:30 PM
> To: smf_addin@yahoogroups.com
> Subject: [smf_addin] 1000 Input Tickers Worksheet
>
> This is an awesome template. I have a few questions.
>
> 1. The buttons (Link, Remove Link, Force) do not work for me. I get
> an error message. Anyone know what is causing this or what the
> purpose of the buttons is?
>
> 2. I am able to change/replace a ticker but I am not able to add a
> new row altogether. Does anyone know how to add a new row?
>
> 3. What is the meaning of the color codes?
>
> Thanks,
> Andy
>
>
>
> ------------------------------------
>
> Yahoo! Groups Links
>

------------------------------------

Yahoo! Groups Links

Sun Dec 2, 2012 9:37 am (PST) . Posted by:

"ddbohrer" ddbohrer


Randy,

Doing the info in the Link message worked but then it stopped working after I saved it. I tried it again and could not get it to work again.

Daryll
--- In smf_addin@yahoogroups.com, Randy Harmelink <rharmelink@...> wrote:
>
> Check out the location errors item in the LINKS area of the group. You need
> to fix unresolved links.
>
> On Sat, Dec 1, 2012 at 11:55 AM, ddbohrer <ddbohrer@...> wrote:
>
> > I can use the various functions and get them to work. However,when I try
> > to use any of the templates or files I get the following error message
> > response
> >
> > #name? query response
> >
> > I was using the following template but get the same message for other
> > files.
> >
> > smfGetAdvFNElement-Template-All-Line-Items
> >
>

Sun Dec 2, 2012 9:42 am (PST) . Posted by:

"Randy Harmelink" rharmelink

I you fixed the links and saved the workbook, all links should be resolved
when you reopen the workbook you saved. Because the hard-coded links will
reflect where you have the add-in located.

On Sun, Dec 2, 2012 at 10:37 AM, ddbohrer <ddbohrer@gmail.com> wrote:

>
> Doing the info in the Link message worked but then it stopped working
> after I saved it. I tried it again and could not get it to work again.
>

Sun Dec 2, 2012 9:55 am (PST) . Posted by:

"ddbohrer" ddbohrer

I got it to partially work. If I follow your instructions. I still get the error message. However, if I go into each cell copy and repaste it back into the cell it works. confused

--- In smf_addin@yahoogroups.com, Randy Harmelink <rharmelink@...> wrote:
>
> I you fixed the links and saved the workbook, all links should be resolved
> when you reopen the workbook you saved. Because the hard-coded links will
> reflect where you have the add-in located.
>
> On Sun, Dec 2, 2012 at 10:37 AM, ddbohrer <ddbohrer@...> wrote:
>
> >
> > Doing the info in the Link message worked but then it stopped working
> > after I saved it. I tried it again and could not get it to work again.
> >
>

Sun Dec 2, 2012 10:04 am (PST) . Posted by:

"Randy Harmelink" rharmelink

I'm confused as well. What do you get with:

=RCHGetElementNumber("Version")

On Sun, Dec 2, 2012 at 10:55 AM, ddbohrer <ddbohrer@gmail.com> wrote:

> I got it to partially work. If I follow your instructions. I still get
> the error message. However, if I go into each cell copy and repaste it
> back into the cell it works. confused
>

Sun Dec 2, 2012 1:24 pm (PST) . Posted by:

"ddbohrer" ddbohrer


Stock Market Functions add-in, Version 2.1.2012.02.02 (C:\smf add-in; 1)

is the message that I get back

--- In smf_addin@yahoogroups.com, Randy Harmelink <rharmelink@...> wrote:
>
> I'm confused as well. What do you get with:
>
> =RCHGetElementNumber("Version")
>
> On Sun, Dec 2, 2012 at 10:55 AM, ddbohrer <ddbohrer@...> wrote:
>
> > I got it to partially work. If I follow your instructions. I still get
> > the error message. However, if I go into each cell copy and repaste it
> > back into the cell it works. confused
> >
>

Sun Dec 2, 2012 2:07 pm (PST) . Posted by:

"Randy Harmelink" rharmelink

Tell me more about the error message?

On Sun, Dec 2, 2012 at 2:24 PM, ddbohrer <ddbohrer@gmail.com> wrote:

>
> Stock Market Functions add-in, Version 2.1.2012.02.02 (C:\smf add-in; 1)
>
> is the message that I get back
>
> --- In smf_addin@yahoogroups.com, Randy Harmelink <rharmelink@...> wrote:
> >
> > I'm confused as well. What do you get with:
> >
> > =RCHGetElementNumber("Version")
> >
> > On Sun, Dec 2, 2012 at 10:55 AM, ddbohrer <ddbohrer@...> wrote:
> >
> > > I got it to partially work. If I follow your instructions. I still
> get
> > > the error message. However, if I go into each cell copy and repaste
> it
> > > back into the cell it works. confused
>

Sun Dec 2, 2012 12:40 pm (PST) . Posted by:

"zbgb952" zbgb952

Hello Randy. This is now giving me all error messages. It just started to do so. I noticed that Zacks just made changes to their website zacks.com . I wonder if this could be the cause. Can you fix this? Thanks.

Sun Dec 2, 2012 2:03 pm (PST) . Posted by:

"Randy Harmelink" rharmelink

They have indeed made changes.

I just uploaded a new smf-elements-6.txt file to the "Works in Progress"
folder of the FILES area of the group. Hopefully, that will fix all the
Zacks element definitions.

Best practice:

1. Exit EXCEL
2. Download the new version of the element definition file
3. Replace the older version of this file in your add-in's file folder
with the newer downloaded version
4. Restart EXCEL

On Sun, Dec 2, 2012 at 1:40 PM, zbgb952 <mb0329@msn.com> wrote:

> Hello Randy. This is now giving me all error messages. It just started to
> do so. I noticed that Zacks just made changes to their website zacks.com. I wonder if this could be the cause. Can you fix this? Thanks.
>

Sun Dec 2, 2012 2:06 pm (PST) . Posted by:

"zbgb952" zbgb952


Thanks Randy..you're the greatest. Happy Holidays.
--- In smf_addin@yahoogroups.com, Randy Harmelink <rharmelink@...> wrote:
>
> They have indeed made changes.
>
> I just uploaded a new smf-elements-6.txt file to the "Works in Progress"
> folder of the FILES area of the group. Hopefully, that will fix all the
> Zacks element definitions.
>
> Best practice:
>
> 1. Exit EXCEL
> 2. Download the new version of the element definition file
> 3. Replace the older version of this file in your add-in's file folder
> with the newer downloaded version
> 4. Restart EXCEL
>
> On Sun, Dec 2, 2012 at 1:40 PM, zbgb952 <mb0329@...> wrote:
>
> > Hello Randy. This is now giving me all error messages. It just started to
> > do so. I noticed that Zacks just made changes to their website zacks.com. I wonder if this could be the cause. Can you fix this? Thanks.
> >
>

Sun Dec 2, 2012 1:13 pm (PST) . Posted by:

"zbgb952" zbgb952

Randy, how do I use the RCHGetTableCell formula to retrieve the Zacks Rank from the website:

http://www.zacks.com/stock/quote/VZ

I've been playing with it but haven't been successful.

Thanks.

Sun Dec 2, 2012 2:06 pm (PST) . Posted by:

"Randy Harmelink" rharmelink

The formula I am using for the element definition is:

=0+smfStrExtr(smfGetTagContent("
http://www.zacks.com/stock/quote/VZ/detailed-estimates","p",-1,"Zacks
Rank:"),": ","-")

...but you can use the same format with your URL:

=0+smfStrExtr(smfGetTagContent("http://www.zacks.com/stock/quote/VZ","p",-1,"Zacks
Rank:"),": ","-")

On Sun, Dec 2, 2012 at 2:13 PM, zbgb952 <mb0329@msn.com> wrote:

> Randy, how do I use the RCHGetTableCell formula to retrieve the Zacks Rank
> from the website:
>
> http://www.zacks.com/stock/quote/VZ
>
> I've been playing with it but haven't been successful.
>

Sun Dec 2, 2012 2:01 pm (PST) . Posted by:

"smf_addin@yahoogroups.com"


Hello,

This email message is a notification to let you know that
a file has been uploaded to the Files area of the smf_addin
group.

File : /Works-In-Progress/smf-elements-6.txt
Uploaded by : rharmelink <rharmelink@gmail.com>
Description : Contains updates to Zacks data element definitions, which had to be redefined because of URL and page layout changes made by Zacks. These definitions are used by the RCHGetElementNumber() function.

You can access this file at the URL:
http://groups.yahoo.com/group/smf_addin/files/Works-In-Progress/smf-elements-6.txt

To learn more about file sharing for your group, please visit:
http://help.yahoo.com/l/us/yahoo/groups/original/members/web/index.html
Regards,

rharmelink <rharmelink@gmail.com>


Diposting oleh EXCEL FEED LEARNING di 14.07

Tidak ada komentar:

Posting Komentar

Langganan: Posting Komentar (Atom)