I don't use Sharpe Ratio at all, and Bear Market Decline Rank seems pretty undependable though it would be interesting. On the other hand, I really like the...
Hi Randy, I foolishly deleted all the old stuff, including the SMF... .xla main file. When I unzipped the file below, only the financial functions.xla...
Sorry, my zip program put it somewhere else. Should have seen that. Thanks for putting up the new version. Good Saturday night diversion (he says geekishly)....
I just clicked on that link and the compressed folder had 13 files in it. One XLA file (the add-in), one XLS file (with a list of elements), and 11 TEXT files...
... Examples/SMF-Template-smfInCellChart-Basic-Example.xls ... to show several retrieved data items for a stock, for a quick graphical view of the data. ... ...
Actually, I had to delete "rogue" lines quite a bit while testing. It's actually very easy: -- Press F5 to bring up the "GoTo" dialog -- Click on the "Special"...
... in ... because ... that ... Hi Randy, It turns out that the non-self-clearing graphic is only a problem when the "Slope" parameter is on. Without it, each...
Cool! It selects ALL the graphics. However did you find that one !? So I can clear all the overdraws, but a new problem replaces the old. Now, I can't seem...
I'm not seeing your issue in EXCEL 2003. The shape deletion code is independent of the type of chart. However, it does only delete shapes completely within...
This code should delete all shapes within a selected range: Sub smfShapeDelete() If VarType(Selection) <> 8204 Then Exit Sub ' Must be a range nTLR =...
Hi Randy I am using the RCHGetWebData function to extract data from the folllowing website. https://research.stlouisfed.org/fred2/data/CPIULFSL.txt Everything...
Hmmm. No problem accessing it here. But based on my extraction, the 1976-08-01 line starts at position 8174. What technique are you using to parse the data?...
I don't understand it. It happens on 4 different indicators - others work fine. This is what I get. I hard coded the find char formula as this was returning ...
Randy, How odd. The vectors ARE completely within the cell, and it just draws a new vector without first clearing the cell. The chart (no "Slope" parameter)...
I am receiving an error message on all my spreadsheets after downloading the new add-in file from Sep-29. I have extracted the files to my C:/Program...
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 : /Economic...
smf_addin@yahoogroups...
Oct 2, 2007 4:00 pm
2858
... wrote: Hi Randy. I just uploaded my file. The 3 sheets that I have in there are the ones that don't work. Rest are fine. Could you please take a look at...
Just in case it may be an issue -- what version of EXCEL do you use? However, based on your description, my first suspicion would be that you somehow...
Everything works for me. When I first open the workbook, I DO see the error values you mention. However, after the workbook recalculates, the problem no...
Hi Randy, Could you give me any more information on this spreadsheet? What is needed to make it work? Or what website address contains more information?...
It's not something I created. I can point you to the IBD thread where I picked up the update: http://www.investors.com/idealbb/view.asp?topicID=16807 As far...
Randy, thanks for your help. I am using Excel 2003. I checked add-in and I only had one Stock Market Functions add-in which was checked. Then I realized I...
I have added more securities and am trying to accumulate every security that we use into one file. I am attempting to track daily prices and only really need...
You can upload it. I can always turn off automatic calculation before I open it. As far as the dates, I often use a future date with smfPricesBetween(). For...
Thanks for adding that Risk Measures page. Would it be possible to also add the cell labeled "Best-Fit Index"? In other words, to report which index they used...
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.
