How do I start using this spreadsheet? Â Thanks How do I start using this spreadsheet? Thanks...
10101
derekfluker
May 1, 2010 3:31 pm
I installed the lastest AddIn from the Files area. Now everytime I open Excel I get a message title: "Repairs to RCH_Stock_Market_Functions.xla" body: "This...
10102
Randy Harmelink
rharmelink
May 1, 2010 3:32 pm
By going through the documentation in the "Documentation" folder of the files area... On Sat, May 1, 2010 at 6:30 AM, Avelino De Sousa...
10103
Randy Harmelink
rharmelink
May 1, 2010 3:34 pm
Sounds like the XLA file got corrupted somehow. Try this: 1. In EXCEL, deactivate the add-in from the add-in manager 2. Exit EXCEL 3. Download a new version of...
10104
jhfrazer@...
jhfrazer...
May 2, 2010 3:39 pm
Good morning all, Sorry to have so many questions on a Sunday morning but here is my situation; Last evening on my laptop computer (Win7 Excel 2007) I added...
10105
Randy Harmelink
rharmelink
May 2, 2010 3:47 pm
See: http://finance.groups.yahoo.com/group/smf_addin/message/4918 http://finance.groups.yahoo.com/group/smf_addin/message/9952 I gave up on using "Edit Links"...
10106
Gennady Kupershteyn
gennady17
May 3, 2010 1:40 am
The following element #'s aren't working anymore: 561, 562, 563, 564 - retrieves yahoo estimates 7 days ago for the next 2Q's and years. 4811 - morningstar...
10107
Randy Harmelink
rharmelink
May 3, 2010 2:10 am
It appears Yahoo dropped a leading blank on the descriptions in the table -- used to be " 7 days ago", now is "7 days ago". I was getting "Error" on them, not...
10108
Gennady Kupershteyn
gennady17
May 3, 2010 2:17 am
This is the formula: =RCHGetElementNumber(AMVIX, 4811, "" ) It's not working for any of my symbols. Which element file do I have to make the yahoo change in? ...
10109
Randy Harmelink
rharmelink
May 3, 2010 2:34 am
The ticker symbol needs to be passed as a string. That is: =RCHGetElementNumber("AMVIX", 4811, "" ) As you have it, it would be looking for a range named...
10110
Gennady Kupershteyn
gennady17
May 3, 2010 2:38 am
I tried it like this, =RCHGetElementNumber("AMVIX", 4811, "" ), and still nothing. Or did I misunerstand you? Gennady Kupershteyn Follow me on Twitter or...
10111
Randy Harmelink
rharmelink
May 3, 2010 2:44 am
For me: =RCHGetElementNumber("AMVIX", 4811, "" ) ...is returning: Fund: American Century Veedot Inv Did you create a current cookie for the MorningStar site...
10112
Gennady Kupershteyn
gennady17
May 3, 2010 2:54 am
Strange, but it's not working. I pasted it in exactly as you wrote it. Then typed it. Nothing. It's possessed. I've been working at this for a few weeks now. ...
10113
Randy Harmelink
rharmelink
May 3, 2010 3:06 am
The cookie issue is one reason I rarely use MorningStar. If you use any MorningStar elements before creating the cookie, you need to: 1. Create the cookie. 2....
10114
Gennady Kupershteyn
gennady17
May 3, 2010 3:18 am
Still nothing. I need to sleep on it. Gennady Kupershteyn Follow me on Twitter or Capitalist Bull Subscribe to Capitalist Bull by Email ... From: "Randy...
10115
kivikatz
May 3, 2010 5:40 am
Is there any way to get last price quotes for options using the new symbols (i.e., "ASF100522C00025000"). I looked through the files section and message...
10116
Randy Harmelink
rharmelink
May 3, 2010 6:08 am
Check out the "Links" area of the group. You'll find links to messages with formulas for Yahoo, MSN, and OX. I've also got functions in the hopper for the next...
10117
PLA
option2z
May 3, 2010 3:36 pm
Thanks Randy. It is as I feared. I think I'll try to devise some VBA that returns what gender a ticker is: Stock, ETF, of MF. Then a decision tree as to...
10118
Jacob Jose
pepecan47
May 3, 2010 6:58 pm
Randy, ... Â Which one do you use, ta-lib.xll or ta-lib-reverse.xll? Regards, Jose L. Jacob ________________________________ From: Randy Harmelink...
10119
Randy Harmelink
rharmelink
May 3, 2010 7:04 pm
I use ta-lib.xll so that it's consistent with the sort order I use in smfTech()....
10120
David
ddevejian
May 3, 2010 11:06 pm
Im using Office Pro Plus 2010 Beta on Windows 2010 Home. I can use the function RCHGetElementNumber, but RCHGetYahooQuotes will crash Excel. Im using the...
10121
Randy Harmelink
rharmelink
May 3, 2010 11:17 pm
Can you step through the VBA code to see where it's crashing?...
10122
PLA
option2z
May 4, 2010 6:07 am
Randy, Sorry I somehow missed this reply, and found it while cleaning out a folder. I'm quite sure that there are times when monthlies expire a day early ...
10123
Randy Harmelink
rharmelink
May 4, 2010 6:25 am
I would actually key everything off the future ticker symbol. If you look at the "Details" link for the call and the puts, they have both the temporary and the...
10124
PLA
option2z
May 4, 2010 6:54 am
As always, thanks for your nearly real-time reply, and for its precision. But, HEY, it is late and we should all be in bed, so I'll check it out in detail...
10125
Rob
rjmnutter
May 4, 2010 3:36 pm
I had been running element numbers 1223, 1256, 1257, 1258 & 1271 from barchart.com but they are producing "Error" as the result today. I have tried the...
10126
Erich
erichplace
May 4, 2010 4:26 pm
Want to make sure it is a system problem and not my pc. When I go to files and try to open a file, such as "1.0 - Overview.html", I am getting the error...
10127
Randy Harmelink
rharmelink
May 4, 2010 4:40 pm
I just updated all of the Barchart.com element definitions for their site redesign. You can pick up the new version of the smf-elements-9.txt file from the...
10128
Randy Harmelink
rharmelink
May 4, 2010 4:41 pm
Must have been a temporary Yahoo glitch -- the file is available now....
