Hi Excel hard codes the location of the addin in every cell. If that part of the cell address matches where you have the addin, then it is not displayed and...
The dimension of the array returned is defaulted to 10x10. You need to pass the pDim1 and pDim2 parameters to specify the number of rows and number of columns...
Thanks Randy! Works like a charm! Can you do the same thing with smfGetCSVFile? I see pdim1:=200 and pdim2:=100 in RCHGetYahooQuotes but don't know how to...
I didn't bother to set it up for smfGetCSVFile(), because all that function does is call RCHGetYahooQuotes(). So, you can use the RCHGetYahooQuotes() function...
I would just use the RCHGetYahooHistory() function once to get all of the history you need, then extract the derived metrics you desire from that range of...
I meant to say that I got the same number in each row of the column. Sorry. I thought that my mistake was trying to list vertical prices from horizontal...
Abandon the concept of using the smfPricesBetween() function. It returns up to 10 specifically defined items for a specific date range. Not multiples of ...
The Accrued Interest function in Excel returns a wrong number for a bond purchased in the secondary market. Is anyone else aware of this problem? Does anyone...
I am using RCHCreateComment("MMM",1) function. I get six month. Is there a way to change it to a different time period i.e. a year, 5 years. Thank you!...
You can always pass a URL of a custom image if you use 99 as the second parameter, as long as the URL is less than 100 characters in length (an EXCEL...
Hi I have been trying to get the option bid/ask for the RUT index and cannot get them. I only would like to reteave a limited set - not the whole set. Could...
If the previous answer was insufficient, I'll need more details as to why. What options can't you get? What source are you using? What web page are you seeing...
I did get some returns - but not all, just Error. I had returns for the Febuary 610,680,690 both Puts and Calls, bid and ask. But Errors on the 580 and 590's....
... RCHGetTableCell("http://finance.yahoo.com/q?&D3,1,"Ask:") and "Bid:". It returned a value for RUY100220C00680000 the 680 strike and also the 690, 610...
The 580 and 590 strike prices are working fine for me -- are you using the proper ticker symbols? They don't use the RUY prefix. RUW100220C00580000 ...
A very comprehensive answer, telling me exactly what I needed. Thanks so much, Randy! My skills as a Stock Analyst are growing exponentially with your...
Thank you very much, that was the problem. I thought they had changed to only one symbol for each underlying. How do I refresh them - re-enter or is there a...
Long-term, it's supposed to be one symbol for each underlying. But not during the transition (i.e. thru May). See: http://biz.yahoo.com/opt/symbol.html For...
Thank you. Two questions: In this string =RCHCreateComment("http://stockcharts.com/c-sc/sc?s=IBM&p=D&yr=3&mn=0&dy=0&i=0&r=2274",99), if stock symbol is stored...
Hi, I have been using the function RCHGetYahooHistory for a while now. If I set the dates to retrieve data from (note UK date style) 01/01/2009 to 02/02/2010 I...
Exact formula invocation please, so I can see just what you're passing for each parameter. For my own usage, I rarely use the date parameters. If your ending...
Okay, this is strange I get the full history for DGO.L but not the full history for RKH.L Yet both full histories are downloadable and viewable on the yahoo...
