Search the web
Sign In
New User? Sign Up
smf_addin · EXCEL Stock Market Functions Add-in
? Already a member? Sign in to Yahoo!

Yahoo! Groups Tips

Did you know...
Want your group to be featured on the Yahoo! Groups website? Add a group photo to Flickr.

Best of Y! Groups

   Check them out and nominate your group.
Having problems with message search? Fill out this form to ensure your group is one of the first to be migrated to the new message search system.

Messages

  Messages Help
Advanced
Messages 4074 - 4103 of 7906   Oldest  |  < Older  |  Newer >  |  Newest
Messages: Simplify | Expand   (Group by Topic) Author Sort by Date ^
4074
Maybe I address this issue directly to the group... ... From: Fab K <fabkl23@...> To: Randy Harmelink <rharmelink@...> Sent: Thursday, May 1, 2008...
Fab K
fabkl23
Offline Send Email
May 1, 2008
5:17 pm
4075
The second parameter of the RCHGetYahooHistory() function is a date field, not a character field. But I don't get an EXCEL error message when I use the...
Randy Harmelink
rharmelink
Offline Send Email
May 1, 2008
5:19 pm
4076
In message 4045 "rtexican" <RHerb505@...> asked: “Has anyone used Quattro Pro for the SMF_Add-In?” The SMF-Add In does not work with Quattro Pro. I own...
JimMorlock@...
kagawonger
Offline Send Email
May 1, 2008
6:57 pm
4077
thanks a lot... I meant "GetYahooQuotes" instead of "GetYahooHistory".. sorry for that. but I still get an error message while either typing: - ...
Fab K
fabkl23
Offline Send Email
May 1, 2008
7:00 pm
4078
Dear group members, I have designed excel spread sheet for INTRA DAY Trading, I want to market it,can I put some time controll device,so that sheet will become...
vilasva
Offline Send Email
May 1, 2008
7:33 pm
4079
I can't be of much help if you have different regional settings -- I just don't have the experience with the idiosyncrasies that may occur. As you noted, you...
Randy Harmelink
rharmelink
Offline Send Email
May 1, 2008
9:06 pm
4080
Thanks I even downloaded the trial Version of X4 and nothing works there either. I appreciate your reply .. Richard From: smf_addin@yahoogroups.com...
RichardH
rtexican
Offline Send Email
May 2, 2008
12:06 am
4081
First, kudos and hats off to Randy Harmelink and others to create such a great yahoogroup. One of would have thought that automatic download of stock...
Zeo Xer
zxbir
Offline Send Email
May 2, 2008
4:00 am
4082
I just opened "SMF-Template-Yahoo-Analyst-Estimates.xls" from the files area, used ticker MMM, and it worked fine for me. You can pick up the "Price Target...
Randy Harmelink
rharmelink
Offline Send Email
May 2, 2008
4:08 am
4083
I hope the software/spreadsheet that you're looking to sell isn't using the wonderful code that Randy's given to us at no cost. I think that would really go...
jjcampnr
Online Now Send Email
May 2, 2008
5:26 am
4084
Hmm - for some reason, I get 'Undefined' in all the cells. Even when I try =RCHGetElementNumber("IBM", 760), I get 'undefined'. FYI - My computer is connected...
Zeo Xer
zxbir
Offline Send Email
May 2, 2008
11:28 am
4085
since I know that the different behaviour may come from the different regional settings I have changed it respectively. the problem with excel hanging I...
Fab K
fabkl23
Offline Send Email
May 2, 2008
11:42 am
4086
Sounds like you didn't unzip all of the *.txt files in the same directory as the add-in. They contain the definitions of how to extract the elements, so if...
Randy Harmelink
rharmelink
Offline Send Email
May 2, 2008
2:55 pm
4087
You'd need to change the search string of the function, as in: ...
Randy Harmelink
rharmelink
Offline Send Email
May 2, 2008
2:59 pm
4088
Sorry to beat a dead horse... The beginning of this e-mail string implies that the SMF_AddIn works with Forbes website. Have others had similar success? If...
SundermanJ
Offline Send Email
May 2, 2008
3:16 pm
4089
Not a dead horse... The general form for elements in that particular table would be something like: =RCHGetTableCell(url,column,">Agreement<",,,,row) ...where...
Randy Harmelink
rharmelink
Offline Send Email
May 2, 2008
4:03 pm
4090
I notice that the smf-elements-4.txt are not listed in the RCHGetElementNumber-Element-Definitions.xls beginning with the 4671 Morningstar elements. Am I...
rtexican
Offline Send Email
May 2, 2008
6:23 pm
4091
my files have the date 10/24/2007.  maybe you should reinstall from the web site ... From: rtexican <RHerb505@...> To: smf_addin@yahoogroups.com Sent:...
Martin Topper
mtopper
Offline Send Email
May 2, 2008
6:36 pm
4092
I downloaded the add-in from the files area. However, the file date is 9/29/2007 and the definitions are still 8/27/2007. So, where is the new file? ... the...
rtexican
Offline Send Email
May 2, 2008
6:49 pm
4093
The only problem is that you are using the element definitions worksheet with "released" element definitions, but you are using an smf-elements-4.txt file from...
Randy Harmelink
rharmelink
Offline Send Email
May 2, 2008
7:49 pm
4094
I have updated the element definitions to reflect the smf-elements-4.txt file. I did see that element 4905 and 4914 were both listed as "Trailing Returns -...
RichardH
rtexican
Offline Send Email
May 3, 2008
1:01 am
4095
Everything looks fine EXCEPT ... when I expand line 4 in the workbook, not sure what the formulae are SUPPOSED to be. The formula in C4 is: ...
rtexican
Offline Send Email
May 3, 2008
2:40 pm
4096
??? There should be no formula in cell C5. The formulas you cite below should be the two in cells C4 and D4. Cells C$5 and D$5 contain the "Source" and...
Randy Harmelink
rharmelink
Offline Send Email
May 3, 2008
4:35 pm
4097
Sorry to be asking a dumb question: What is the meaning of ElementNumber in RCHGetElementNumber? And where can I get a list telling which ElementNumber...
Vinay Gakkhar.
vgakkhar
Offline Send Email
May 4, 2008
3:22 am
4098
RCHGetElementNumber() is one of the functions of the add-in. In the context of the thread, "ElementNumber" was just being used as a shorter name of the...
Randy Harmelink
rharmelink
Offline Send Email
May 4, 2008
3:26 am
4099
Whoops! My Bad. The formulae are in C4 and D4. I stated C5 which is in error. I totally misread the action because B4 is blank for the initial formula which...
RichardH
rtexican
Offline Send Email
May 4, 2008
2:07 pm
4100
Hi guys, I am playing around with the options spread sheet I found in the files section and got a quick question. Anyone know how i can edit the option price...
Jim_Boukis
Offline Send Email
May 4, 2008
3:10 pm
4101
You want to use EXCEL's conditional formatting feature. See this tutorial: http://www.contextures.com/xlCondFormat01.html...
Randy Harmelink
rharmelink
Offline Send Email
May 4, 2008
3:12 pm
4102
thanks for the link its very helpful. The only problem is the option prices on yahoo and all the other sites ive seen are all quoted in positive terms, so i...
Jim_Boukis
Offline Send Email
May 4, 2008
4:10 pm
4103
I hadn't noticed that it was only reporting positive amounts before. An alternative route would be to use the template's processing to gather the options...
Randy Harmelink
rharmelink
Offline Send Email
May 4, 2008
5:18 pm
Messages 4074 - 4103 of 7906   Oldest  |  < Older  |  Newer >  |  Newest
Advanced
Add to My Yahoo!      XML What's This?

Copyright © 2009 Yahoo! Inc. All rights reserved.
Privacy Policy - Terms of Service - Guidelines - Help