hmmm.Okay I guess I'm just confused how you can get all the MSTAR data that you do but the tax cost isn't 'gettable'. Â I'm not a techie so I don't understand...
Randy, I have a spreadsheet that has worked fine for a few years. Today for the first time in a few months I ran it and got all #VALUE! in all the cells in my...
Looks like you have your work cut out for you... From: Jim Jones Sent: Saturday, January 01, 2011 1:38 PM To: smf_addin@yahoogroups.com Subject: Re:...
... That's so IF the division or the CDec() conversion causes an error, it leaves variable "s1" as is. Have you maybe changed your VBA settings? If you have...
Well, what happens is that add-in grabs the source code of the web page, then extracts data from that source code. What happens in your browser is that it...
Where can I get price channel high/low in a way that I can use the smf_addin to get them to an Excel spreadsheet?  Regards, Jose L. Jacob Where can I get...
I just downloaded this and opened it in excel and have no idea how to proceed: I see a row at the top that says (#; Source; Element; Template) and then there...
You need to head to the "Documentation" folder of the files area for installation instructions and documentation on the various functions. Also, the "Links"...
Randy, I just started using your smf_addin and I find that it is just what I was looking for. I just want to thank you for your programming work and your...
It's working for me for every source except MSN, and if I go to MSN with my browser, it says "No options listed" for PG: 1b 2b 3b 4b 5b Bid Price Bid Price...
Hi Randy, I have installed the add-in as instructed by you; however, the it does not seem to be functioning. Can you guide with the changes that need to be...
There are no changes to be made to the macro settings -- they are irrelevant for an add-in. When do you get the security message, and which version of EXCEL?...
You're saying you see the message when you start up EXCEL, before you open a workbook? In a new workbook, what happens when you enter this formula: ...
Since I last ran your macros on an XP running excel 2007 computer, I have since bought a new computer loaded with Windows 7 Home Premium 64 bit OS (first time...
Yes... I get the version of the add-in when I enter this command..However, one of my previous works, which I made using ur add-in does not seem to be showing...
Ok..Now I know where the problem lies....I had to change the directory from where the add-in was being picked....In my sheet, it picked from C:\SMF, but in...
The add-in is NOT the issue -- it *IS* functional, if it's giving you the version number. What messages do you get when you click on the "Options" button --...
That's because EXCEL hard-codes the location of the add-in when it saves a workbook. So when you open a workbook and the add-in isn't in that hard-coded...
The location of the add-in can literally be anywhere. It doesn't matter. The only time the location is relevant is when you open an EXCEL workbook that uses...
Randy, why can't you resolve this by recommending a fixed location for the Add-in doing the install process? Then making sure all your templates and files...
Thanks Randy ... the prices are working fine this AM Richard From: Randy Harmelink Sent: Sunday, January 02, 2011 5:32 PM To: smf_addin@yahoogroups.com ...
The installation process does recommend a fixed location. However, I can no longer use that location because Vista wouldn't allow me to update the add-in in...
I am still trying to figure out how this add-in works. I have used the addin to get stock quotes and it works well. I am having trouble with using the...
Randy, Do you have an Etrade account? I was hoping to get help extracting the EPS and Revenue estimates that they have going out more then 2 quarters and...
Do you have the latest version of the add-in? That is a new function that was recently added. This will tell you what version of the add-in you are using: ...