Hi Folks, I had no problem installing SMF the first time around, but since wiping my hard drive + OS last week (running XP SP3) I can't seem to get SMF working...
Your question got me thinking. I started copying / pasting formula examples into my reply and realized the RCH's were prefaced by drive addresses (c:\Program...
Yup. Common issue, thanks to Microsoft. See: http://finance.groups.yahoo.com/group/smf_addin/message/4918 Once you fix the links and save the worksheets,...
If you have cleaned up you OS and then re installed, make sure these things are correct. 1) make sure all the add in files are in c:/program file/SMF Add-In 2)...
Randy, I have a #NAME? error. Here are the conditions: =RCHGetElementNumber("Version") results in Stock Market Functions add-in, Version 2.0j Formulas such as...
The only reason I can think of for a newly entered RCHGetTableCell() function to return #NAME? when the other functions are working is if something happened to...
I downloaded again the zip file and extracted it into the C:\Program Files\SMF Add-In folder. Same results as before. So I took a completely fresh, new...
Dear Randy Nice tools you created. I'm a newbee with the tool and for now just messing arround with it. As in our country the decimal separator character is a...
Randy Add-on on previous post As in our country the decimal separator character is a comma and not a dot as in most countries, there is a small VBA issue wirdt...
What low-cost brokers can you recommend for a beginning low volume trader? Also, is there any way to get short interest or ratio on a historical basis? Thank...
... I'd suggest a Google search and you'll find plenty of broker comparison pages. I use Wells Fargo's PMA account, which gives me 100 commission-free trades...
I'll have to take another look at it when I get a chance. I had someone suggest VAL() as a solution a year or so ago. I made the change and ran into a few...
nTemp is only used to stay close to your code to check if the contents of the string is a value. If a string does not contains numbers the val() function will...
Thank you - that's exactly what I need. I know there are a lot of pages about brokers but I'm interested in direct experience instead of their hype pages....
Randy: After installing smf_addin and reading documentation, I am trying some simple examples first for retrieving data. Problem: I used the following...
Your steps worked for me. Randy might ask if you get a result from the following formula (not array entered) =RCHGetElementNumber("Version") Marty ...
... the following formula (not array entered) ... Marty: This is the result: Stock Market Functions add-in, Version 2.0j I went to traineetrader.com and tried...
As per Martin, it works fine for me. What version of EXCEL are you using? What operating system? Are your regional formatting options set to "English (United...
Also -- what leads you to the conclusion "does not seem to be connecting" (versus getting the data but not interpreting it correctly)? Do you have some type...
Randy and Marty: I got the small example to work below by reentering...and I then used the insert function for YahooQuotes, input IBM,CSCO after formatting ...
I would suggest Folioinvesting.com. $290 a year fee and no commissions--don't know the minimum account value. Betty G (My current account balance is less...
Check out Interactive Brokers.Jim----- Original Message -----From: Smart Choices Date: Monday, May 4, 2009 12:37 pmSubject: [smf_addin] Broker and Historical...
I have modified one of the files from Templates and Examples, RCHGetYahooQuotes. Added columns for portfolio bought price, # shares, cost and current value of...
... Actually, the "IF" statements are just allowing you to use meaningful names for the columns and then it "looks up" the Yahoo code to use for that column...
Greetings, Can anybody offer a tip - I have entered the following formula in an array =RCHGetYahooQuotes(A9:A300,B8:U8,,"NOW()",,) I am getting all data...
Sometimes, I have to examine the source code to find what would be a unique search string. I often use the ">" prefix so that the strings will be found as...
You're close. Just remove the double quotes around NOW(). You have it coded as a literal instead of invoking the NOW() function. On Tue, May 5, 2009 at 12:38...
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.
