Maybe I address this issue directly to the group... ... From: Fab K <fabkl23@...> To: Randy Harmelink <rharmelink@...> Sent: Thursday, May 1, 2008...
4075
Randy Harmelink
rharmelink
May 1, 2008 5:19 pm
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...
4076
JimMorlock@...
kagawonger
May 1, 2008 6:57 pm
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...
4077
Fab K
fabkl23
May 1, 2008 7:00 pm
thanks a lot... I meant "GetYahooQuotes" instead of "GetYahooHistory".. sorry for that. but I still get an error message while either typing: - ...
4078
vilasva
May 1, 2008 7:33 pm
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...
4079
Randy Harmelink
rharmelink
May 1, 2008 9:06 pm
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...
4080
RichardH
rtexican
May 2, 2008 12:06 am
Thanks I even downloaded the trial Version of X4 and nothing works there either. I appreciate your reply .. Richard From: smf_addin@yahoogroups.com...
4081
Zeo Xer
zxbir
May 2, 2008 4:00 am
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...
4082
Randy Harmelink
rharmelink
May 2, 2008 4:08 am
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...
4083
jjcampnr
May 2, 2008 5:26 am
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...
4084
Zeo Xer
zxbir
May 2, 2008 11:28 am
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...
4085
Fab K
fabkl23
May 2, 2008 11:42 am
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...
4086
Randy Harmelink
rharmelink
May 2, 2008 2:55 pm
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...
4087
Randy Harmelink
rharmelink
May 2, 2008 2:59 pm
You'd need to change the search string of the function, as in: ...
4088
SundermanJ
May 2, 2008 3:16 pm
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...
4089
Randy Harmelink
rharmelink
May 2, 2008 4:03 pm
Not a dead horse... The general form for elements in that particular table would be something like: =RCHGetTableCell(url,column,">Agreement<",,,,row) ...where...
4090
rtexican
May 2, 2008 6:23 pm
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...
4091
Martin Topper
mtopper
May 2, 2008 6:36 pm
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:...
4092
rtexican
May 2, 2008 6:49 pm
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...
4093
Randy Harmelink
rharmelink
May 2, 2008 7:49 pm
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...
4094
RichardH
rtexican
May 3, 2008 1:01 am
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 -...
4095
rtexican
May 3, 2008 2:40 pm
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: ...
4096
Randy Harmelink
rharmelink
May 3, 2008 4:35 pm
??? 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...
4097
Vinay Gakkhar.
vgakkhar
May 4, 2008 3:22 am
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...
4098
Randy Harmelink
rharmelink
May 4, 2008 3:26 am
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...
4099
RichardH
rtexican
May 4, 2008 2:07 pm
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...
4100
Jim_Boukis
May 4, 2008 3:10 pm
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...
4101
Randy Harmelink
rharmelink
May 4, 2008 3:12 pm
You want to use EXCEL's conditional formatting feature. See this tutorial: http://www.contextures.com/xlCondFormat01.html...
4102
Jim_Boukis
May 4, 2008 4:10 pm
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...
4103
Randy Harmelink
rharmelink
May 4, 2008 5:18 pm
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...
