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 : /Add-In...
2
Randy Harmelink
rharmelink
Jun 19, 2006 10:57 pm
Changes for release 1.2f -- Percentage field strings now converted to numeric values -- Obsoleted a number of BWOpin items due to web page changes: -- Fair...
3
fatpitchfinancials
fatpitchfina...
Jun 20, 2006 7:49 pm
Thanks for the update. Keep up the great work! By the way, I'd love to share my discovery of your Excel Add-In with my blog readers. Would you mind if I tell...
4
Randy Harmelink
rharmelink
Jun 20, 2006 8:14 pm
... No problem. The more people using it, the more likely errors are to be found and eliminated. All the better reason for having a separate Yahoo group....
5
Randy Harmelink
rharmelink
Jun 21, 2006 6:38 pm
I just uploaded version 1.3a of the add-in to the library. The main purpose of this version was to rewrite how data elements are extracted off of the web...
6
McGurck
Jun 22, 2006 4:51 pm
RCHGetElementNumber("IBM", 25) works correctly producing the last trade price for IBM. However, RCHGetElementNumber("SPY", 25) just produces an error. -- Joe...
7
Randy Harmelink
rharmelink
Jun 22, 2006 8:00 pm
... The add-in can only retrieve what the data sources provide. Element number 25 is the "Last Price" from the MSN Print Report for stocks. However, SPY is an...
8
smf_addin@yahoogroups...
Jun 23, 2006 2:01 am
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 :...
9
smf_addin@yahoogroups...
Jun 30, 2006 7:36 pm
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 :...
10
Randy Harmelink
rharmelink
Jul 2, 2006 12:16 am
Changes for release 1.3b -- Added a number of mutual fund data elements from Yahoo Finance -- Added 10 years of annual financial statement data from AdvFN --...
11
fatpitchfinancials
fatpitchfina...
Jul 2, 2006 3:43 am
Thanks for the great work. I'll be putting this version of the add-in to use tomorrow. George...
12
owmcclure
Jul 2, 2006 9:31 am
Hi, Just started using the add-in on the recommendation of George at Fat Pitch Financials. Really like what i've seen so far. I have a copy of queries... The...
13
Randy Harmelink
rharmelink
Jul 2, 2006 1:50 pm
... Any time you need a formula to return a range of data, you have to array enter it (Ctrl-Shift-Enter instead of just Enter). A formula can only return data...
14
Randy Harmelink
rharmelink
Jul 4, 2006 4:35 am
I've created a new folder to the library, "Templates and Examples". The first upload there is file SMF-Charts.XLS. It does require version 1.3b of the...
15
Bharani Ellore
ebharani
Jul 4, 2006 3:10 pm
Keep up the good work guys!!!. ... From: Randy Harmelink <rharmelink@...> To: smf_addin@yahoogroups.com Sent: Monday, July 3, 2006 11:20:46 PM Subject:...
16
Kermit W. Prather
kermitpra
Jul 4, 2006 9:02 pm
Not sure what I did wrong but when I tried to replace version 1.2 with 1.3B it does not appear to have added the add-in. It is not list among the add-ins...
17
Randy Harmelink
rharmelink
Jul 4, 2006 10:07 pm
... I think I caused this error. When I rebuilt the add-in to reduce the space down from 8MB to 3MB, I named it internally as "Stock Market Functions Add-In"....
18
Ron Gaillard
rgaillard
Jul 4, 2006 10:25 pm
The same problem occurred for me when I installed the latest version. Nothing seems to work now. ... From: smf_addin@yahoogroups.com...
19
rgaillard
Jul 4, 2006 10:37 pm
replys the word "Stock" in the block ... the...
20
Randy Harmelink
rharmelink
Jul 4, 2006 11:00 pm
... When I enter: =RCHGetElementNumber("Version") I get this value in the cell: Stock Market Functions add-in, Version 1.3b So you must only be seeing the...
21
Ron Gaillard
rgaillard
Jul 5, 2006 1:38 am
it was a clean worksheet, but I did it again on a new worksheet, and this time I got the same as you did. In the addin menu I see Stock Market Functions...
22
Ron Gaillard
rgaillard
Jul 5, 2006 1:48 am
Strange things happening: Excel locked up. Rebooted reloaded Excel with clean workbook entered =RCHGetYahooHistory("DIS",2004,1,1,2004,12,31,"d") Cell...
23
Randy Harmelink
rharmelink
Jul 5, 2006 2:34 am
... Are you sure it's locking up? It can take 30-40 seconds to update all of the calculations. During that time, I see an hourglass, but no note on the...
24
Kermit W. Prather
kermitpra
Jul 5, 2006 2:58 pm
It says I have Stock Market Functions add-in, version 1.3b So at least we have the correct version However, when I open the SMF-Charts.XLS I get message about...
25
Kermit W. Prather
kermitpra
Jul 5, 2006 3:07 pm
Randy, in my case I think the problem is that it is looking for RCH_Stock_Market_Functions not Stock Market Functions. I think you have confused us and Excel...
26
Randy Harmelink
rharmelink
Jul 5, 2006 4:34 pm
... Did you try the different paths I described in message 23? When I went through that process, I found out that when you save a workbook that uses add-in...
27
Kermit W. Prather
kermitpra
Jul 5, 2006 4:35 pm
I followed your steps and when I did #6 I still got the #name in all the cells for the smf-charts.xls workbook. Kermit Prather "Never be afraid to ask...
28
Randy Harmelink
rharmelink
Jul 5, 2006 4:52 pm
... With or without an hourglass? If without, check to see what the #NAME? formulas are referring to. For example, when I went throught the steps, one of mine...
29
rgaillard
Jul 5, 2006 5:33 pm
Sorry, it took so long to get back to you. My head still hurts from last nights celebrations. Excel did in fact lock up along with some other programs I was ...
30
Ronald McEwan
ronmac17
Jul 5, 2006 6:48 pm
All I did to fix the problem was to update the link source to the folder I had put the addin. Works fine now....
