You should be able to fill in from this site: http://unicorn.us.com/advdec/ ...although their numbers don't match Yahoo's exactly. But the values do vary...
7119
Ronald McEwan
ronmac17
Aug 1, 2009 12:36 pm
http://unicorn. us.com/advdec/ Randy, I noticed from the Unicorn link that they have another link to: http://www.marketvolume.com/quotes/advance_decline.asp ...
7120
Randy Harmelink
rharmelink
Aug 1, 2009 6:04 pm
Just try something of the general format: =RCHGetTableCell(URL,column,indextag) For example: ...
7121
Mark Bray
mj_bray
Aug 1, 2009 6:05 pm
Thanks Randy and Ron, MUCH APPRECIATED. I wasn't aware of this site. I knew you guys would come through. Mark B...
7122
Ronald McEwan
ronmac17
Aug 1, 2009 6:19 pm
Thanks Randy, never used this function to much. It's a big help ________________________________ From: Randy Harmelink <rharmelink@...> To:...
7123
Henri Cazeault
hen1944
Aug 1, 2009 10:10 pm
Many thanks for the info ; it does not work up to now for me. But I may be at fault ( a real newbie for sure I am) I have version 2.0j of the addin : is it...
7124
polandaje
Aug 2, 2009 1:38 am
Hi, Thanks for reading this. I'm new to this group. I've setup excel 2007 to manually recalc the RCHGetElementNumber() and the RCHGetYahooQuotes functions...
7125
Randy Harmelink
rharmelink
Aug 2, 2009 1:50 am
Application.Volatile only marks the function the statement is in as volatile. It won't affect any of the add-in functions that are invoked in their normal...
7126
r f
inkt2002
Aug 2, 2009 9:04 pm
Hi group, I was wondering if anyone has an Excel template or list of good formulas to analyze portfolio returns. Any help or insight is greatly appreciated....
7127
polandaje
Aug 2, 2009 10:44 pm
Great, thanks!...
7128
Gene Simon
gsimon408
Aug 3, 2009 4:27 am
Randy, I just noticed an error in file SMF-Template-Morningstar-Total-Return_old.xls. Column E should be titled "+/- Index" and column F should be "+/-...
7129
Randy Harmelink
rharmelink
Aug 3, 2009 2:20 pm
Oops. Good catch, thanks. I've uploaded a replacement file....
7130
r f
inkt2002
Aug 3, 2009 8:09 pm
Hi group, Attached is a spreadsheet with 2 portfolios (1 on sheet 1 and 1 on sheet 2). Portfolio 1 is somewhat like a bond, the portfolio value stays the same,...
7131
Carmine
carmine288
Aug 5, 2009 4:31 am
How do one view the XML historical data?...
7132
Randy Harmelink
rharmelink
Aug 5, 2009 5:20 am
It opens fine with EXCEL 2007. If you have earlier versions of EXCEL, you could get a compatibility pack from Microsoft: ...
7133
lumsdlx
Aug 5, 2009 3:45 pm
I am trying to return the name of a stock for a ticker. For instance in column A 'Ticker' MSFT -- column B 'Name' Microsoft Corporation. I'm pretty sure I...
7134
brigity10
Aug 5, 2009 4:04 pm
Is there a way around the 1000 web page limit or is that an Excel limit? I am looking at pulling around 25 elements for about 200 stocks....
7135
Martin Topper
mtopper
Aug 5, 2009 4:16 pm
=rchgetyahooquotes("mmm","n") returns 3M COMPANY ________________________________ From: lumsdlx <lumsdlx@...> To: smf_addin@yahoogroups.com Sent:...
7136
Martin Topper
mtopper
Aug 5, 2009 4:19 pm
will u be accessing 5,000 web pages, or are multiple data items on one page for each ticker? once you access a web page it is stored in memory (no need to...
7137
Randy Harmelink
rharmelink
Aug 5, 2009 4:21 pm
It's just an arbitrary limit I put in because I thought it should be more than enough and I didn't want to start running into memory limits. However, it's not...
7138
Carmine
carmine288
Aug 5, 2009 6:27 pm
Thanks Randy. I can open up *.xlsx files ok. But the SP500-Historical-Monthly-Total-Returns.xlsx link points to SP500-Historical-Monthly-Total-Returns.zip...
7139
Randy Harmelink
rharmelink
Aug 5, 2009 6:57 pm
Hmmm. I don't see a zip file link on this page: http://jesuswarehouse.com/2009/01/sp-500-total-returns The link I'm looking at just opens the xlsx file...
For me, this link opens a zip file: Link to Excel data file: SP500-Historical-Monthly-Total-Returns.xlsx ...
7142
Randy Harmelink
rharmelink
Aug 6, 2009 2:41 am
For me, it opens up a workbook with three worksheets. However, the FireFox dialog box that asks me what to do with the file does have the "Microsoft Open XML...
7143
Bryce Goehring
brigity10
Aug 6, 2009 2:54 am
Thanks for your quick responses. Some of the items I am pulling are from the http://quicktake.morningstar.com/Stock/Income10.asp and...
7144
Carmine
carmine288
Aug 6, 2009 2:58 am
My problem is IE recognizes it as a ZIP file. I tried: IE 8.0 (Vista) and IE 6.0 (XP) with same results...
7145
Randy Harmelink
rharmelink
Aug 6, 2009 3:52 am
As far as the bond rates are concerned -- no idea here. The add-in can only return what Yahoo provides. You can always find out the web page an elements comes...
7146
Randy Harmelink
rharmelink
Aug 6, 2009 3:52 am
Have you tried changing that setting? http://windowsnerd.com/wp-content/uploads/2009/04/xlsx-problem-zip.jpg...
7147
Gene Simon
gsimon408
Aug 6, 2009 4:09 am
Very strange, the same thing happened to me when attempting to open the same file on jesuswarehouse.com (opened WinZip with a bunch of XML files). The next...
