Randy, I am new to the crew. The spreadsheet is working great on my system. Could you point me to a 'blog' or somewhere that defines each column? Thanks, Ord...
526
John DISTEFANO
SDISTEFANORD
Oct 1, 2006 4:29 pm
I am having problems using the Add-ins on Excel 97.. No problem w/Excel 2003.. My laptop is a bit older running Windows ME. Anyway, I have the Add- ins i n...
527
Randy Harmelink
rharmelink
Oct 1, 2006 6:21 pm
... I'll need more information. I have no idea to what "columns" you are referring?...
528
Ord Nance
ordf15
Oct 1, 2006 6:31 pm
My apologies... I am referring to the columns on the fat pitch finder sprdsht:see example... Is there an 'easy' decoder somewhere? (I've been thru a few...
529
Randy Harmelink
rharmelink
Oct 1, 2006 7:07 pm
... The problem is that whenever someone saves a workbook with add-in functions, the add-in functions are saved as hard-coded references with their location of...
530
Randy Harmelink
rharmelink
Oct 1, 2006 8:36 pm
... The best thing to do is ask George directly. He released the spreadsheet on his blog here: ...
531
Neil Stansbury
nstansbury
Oct 1, 2006 9:24 pm
Sorry! Sure all are syntax errors, issues with parentheses not being closed, the "Split()" method is not found etc. I just post on the off chance as I assumed...
532
Randy Harmelink
rharmelink
Oct 1, 2006 9:38 pm
... Sorry -- I didn't realize you were talking about VBA errors. I only have the one version of EXCEL installed (2002), so have no idea what would need to be...
533
fatpitchfinancials
fatpitchfina...
Oct 2, 2006 1:51 am
I heard my name? Randy got all the columns right except for R2. R-squared is a statistical term that refers to how close of a fit a trend line is to the...
534
drahmir
Oct 2, 2006 4:06 pm
Hello, Thanks for making this great add-on available. It should be a huge time saver. I was curious if there was a way to prevent the spreadsheet from updating...
535
Randy Harmelink
rharmelink
Oct 2, 2006 6:15 pm
... I would think the easiest thing to do would be to copy and paste as values the entire set of prices into a new range (no need to copy "each" price...
536
OHANN AUCAMP
oaucamp
Oct 2, 2006 8:00 pm
Randy Thanks a lot - advice is working mighty fine!!! Johannes Aucamp Mobile - 0944 77 380 43971 58 Church Crescent Muswell Hill N10 3NE From: "Randy...
537
drahmir
Oct 3, 2006 11:08 am
Sorry, that was a matter of ineptitude on my part. I'm relatively new to excel and still learning the ins and outs of it. After your post, I just...
538
eogulnic@...
eogulnic
Oct 3, 2006 3:58 pm
Dear Randy: Can you please briefly explain where and how to down load the add-in and make it functional in Excel. I have attempted to use some of the...
539
drahmir
Oct 3, 2006 4:06 pm
I'm curious if anyone has had any success in finding additional stock data websites that I could retrieve data from that aren't already on the...
540
Randy Harmelink
rharmelink
Oct 3, 2006 6:57 pm
... Most of the additional sites I'd like to add are protected one way or another. Various sites that are on my list to take a closer look at: ...
541
Randy Harmelink
rharmelink
Oct 3, 2006 7:08 pm
First step would be to create this directory on your computer: C:\Program Files\SMF Add-In Next, you'd download the current version of the add-in from this ...
542
Kermit W. Prather
kermitpra
Oct 5, 2006 9:08 pm
BlankIs there anyone else out there using Valueline's daily Option service? It cost $149/yr for that price they update the information twice a day which you...
543
drahmir
Oct 6, 2006 11:10 am
Thanks for the reply Randy. On second thought, i'm considering just constructing the TA signals manually by hand. That would provide a large level of...
544
prosuite
prosuite2000i
Oct 6, 2006 12:06 pm
... Have a look at http://ta-lib.org __________________________________________________ Do You Yahoo!? Tired of spam? Yahoo! Mail has the best spam protection...
545
drahmir
Oct 6, 2006 12:24 pm
I'm running into an error with the RCHGetYahooHistory function. For some reason, if I enter in any October date as the month, I get error messages similar to...
546
prosuite2000i
Oct 6, 2006 1:52 pm
Randy, Using your addins on European systems leads to additional issues. First one is date recognition. To be more explicit, Yahoo Finance date format is...
547
prosuite2000i
Oct 6, 2006 2:10 pm
If you want to add Excel 97 support to your addin, check http://support.microsoft.com/default.aspx?scid=kb;en-us;188007 to Simulate Visual Basic 6.0 String...
548
drahmir
Oct 6, 2006 8:03 pm
prosuite, Thanks for that link. That should save me a lot of time....
549
Randy Harmelink
rharmelink
Oct 6, 2006 8:17 pm
... Another handy souce can be the Chart School over at stockcharts.com: http://stockcharts.com/education/IndicatorAnalysis/index.html Most of the indicator...
550
Randy Harmelink
rharmelink
Oct 6, 2006 8:35 pm
Yup, it is a bug. I was concatenating the beginning and ending year, month, and day, and then comparing them without worrying whether they were 1-digit or...
552
joykill44
Oct 7, 2006 5:47 am
Hey Randy! (...or to anyone else that may be able to answer...) First off, THANK YOU so much for putting this Add-In together!! Truly remarkable work! I've...
553
Randy Harmelink
rharmelink
Oct 7, 2006 6:40 am
... Shouldn't be a problem. The primary reason I use add-ins is so that things are available automatically in any spreadsheet I open. As things are set up...
554
lou_kur
Oct 7, 2006 8:27 pm
Why not just declare the functions as volatile?...
555
Randy Harmelink
rharmelink
Oct 7, 2006 8:58 pm
Far too much unnecessary recalculation would be required. I've had too many worksheets where recalculation can take a LOOOONG time. Besides, it's easy enough...
