hi everyone, i just upgraded to window 7 and now im reinstalling the add in. Can anyone send me instruction on how to do so? Thank you in advance. Tien...
8173
Randy Harmelink
rharmelink
Dec 1, 2009 9:17 am
I would think the installation instructions would depend more upon what version of EXCEL you are using....
8174
konstantinos
nasta256
Dec 1, 2009 1:14 pm
Hi Randy, I want to thank you also for your great work. Unfortunately, i can't use msn elements since it returns "undefined". Tried 2.0h & 2.0k in XP & excel...
8175
Randy Harmelink
rharmelink
Dec 1, 2009 1:17 pm
Sounds like you didn't unzip all of the files out of the ZIP file into the same folder. The element definitions are in the TXT files that are external to the...
8176
key2lif
Dec 1, 2009 6:42 pm
Any idea how we can extract the quarterly financial results from marketwatch.com, it seems they update the financial results much faster (weeks earlier) than...
8177
Tien
littletn04
Dec 1, 2009 6:46 pm
its excel 2007 Warmest Regards, Tien Do ________________________________ From: Randy Harmelink <rharmelink@...> To: smf_addin@yahoogroups.com Sent: Tue,...
8178
Randy Harmelink
rharmelink
Dec 1, 2009 6:56 pm
Just a normal RCHGetTableCell() appears to work fine. For example: =RCHGetTableCell("http://www.marketwatch.com/investing/stock/ ...
8179
Randy Harmelink
rharmelink
Dec 1, 2009 7:00 pm
Do you run into problems following the EXCEL 2007 process defined in the LINKS area of the group? Those are what I used when I upgraded to EXCEL 2007 under...
8180
key2lif
Dec 1, 2009 7:40 pm
Great, that works. However, how do I apply it for a list of stocks without having to have the exact url for the stock ticker. In other words can I automate the...
8181
Randy Harmelink
rharmelink
Dec 1, 2009 8:15 pm
The "Ticker" in the formula is a named range. You can replace it with any cell reference to one containing the ticker symbol you want. For other line items,...
8182
key2lif
Dec 1, 2009 9:09 pm
That did it! MANY THANKS!...
8183
key2lif
Dec 1, 2009 10:31 pm
Is there any way to remove this cap on excel to allow more than the alloted website searches? 1000 gets breached easily when data is being pulled from several...
8184
fincoolio
Dec 2, 2009 1:15 am
sorry for the late reply -- yes, that's all true that I added the VBA code to the workbook only. I will try to figure out how to modify the addin later. ...
8185
Randy Harmelink
rharmelink
Dec 2, 2009 2:10 am
This works for me: =VALUE(smfGetTagContent("http://caps.fool.com/Ticker/ "&H2&".aspx","span";,1,"tickerSentiment")) What error are you getting? PS: The new beta...
8186
randywang888
Dec 2, 2009 5:00 am
Hi, it looks like Google Finance recently changed the format for company financials to include bar charts at the top. As a result, it looks like a few elements...
8187
Randy Harmelink
rharmelink
Dec 2, 2009 5:49 am
What else besides the annual and quarterly revenue figures did you notice were affected? That's all I could see. If that's all you saw that is wrong,...
8188
Randy Harmelink
rharmelink
Dec 2, 2009 6:05 am
It's possible. But there are four primary reasons for the limit: 1. I don't want the free data providers to be overloaded with people trying to build and...
8189
randywang888
Dec 2, 2009 9:24 am
Looks like it was indeed only the annual and quarterly figures. Randy, thank you very much for your help!...
8190
garyhartling
Dec 2, 2009 2:06 pm
What does this function do and what are the parameters? I'd search the smf_addin website but the Yahoo search isn't working. Thx, Gary...
Randy is the ultimate answerer for these sorts of questions, but I would venture to say that since SMF is built on a VBA framework, which is highly Microsoft...
8194
David Rossien
drossien
Dec 2, 2009 3:59 pm
Note that even if you purchase the upgraded DocumentsToGo app: http://www.dataviz.com/products/documentstogo/android/index.html?device_id=633 you STILL won't...
8195
Randy Harmelink
rharmelink
Dec 2, 2009 4:32 pm
I've never even heard of a Motorola Droid. But if it's a stripped down version of EXCEL that doesn't run VBA, then the answer is no....
8196
john_smithman
Dec 2, 2009 6:05 pm
I don't quite know how to describe this, but I'll try. When using the SMF Add-In, I sometimes plug the wrong parameters into the formula, or put the right ones...
8197
Mick
mickest
Dec 2, 2009 6:24 pm
Hi Everyone, I work for a financial company and some of the users here are having an issue with the Bloomberg Add-in. Not sure if there are too many people...
8198
john_smithman
Dec 2, 2009 6:25 pm
Randy, I LOVE your set of functions and I use them everyday to analyze and monitor my stock portfolio in the fancy spreadsheet tables I have created. THANK YOU...
8199
Randy Harmelink
rharmelink
Dec 2, 2009 6:31 pm
I've never seen (or heard of) anything like that. The closest would be that sometimes if I cut and paste a formula from a rich text document, instead of two...
8200
john_smithman
Dec 2, 2009 6:38 pm
I have tried using different computers with different versions of Windows and I still get the sample character-set challenges. Oh well... I'll figure it out...
8201
Randy Harmelink
rharmelink
Dec 2, 2009 7:13 pm
It's not a matter of which function you use, but of which data provider the function is extracting the data from. For example, the "CMG.TO" is what Yahoo...
