Hi Randy, thanks for your answer, but it seems i still am not sure what to do. I found the file you are refering to but it seems that it does not work. Am i...
In order to use the CBOE site, you need to first access the iVolatility data using either the EXCEL Web Query process or IE. That's because the site uses a...
hi, anyone can help if smfPricesByDates(c6,e6,"10") can be arrayed as {=smfPricesByDates(c6:c10,e6:e10,"10")} ? since multiple tickers on column c and multiple...
Hello Randy, I¡¯m curious to know how do you uninstall the SMF add-in? Kind regards, Roc From: smf_addin@yahoogroups.com [mailto:smf_addin@yahoogroups.com]...
Just the reverse of the install: -- Deactivate it from EXCEL using the add-in manager -- Delete the content of and the folder that contained the add-in and its...
The "10" parameter is NOT for smfPricesByDates(), but is used for smfPricesBetween(). But, for the smfPricesByDates(), you can do a range of dates, but NOT a ...
you may find worldwide stocks and indexes on yahoo sites for other countries and regions http://uk.finance.yahoo.com/ <http://uk.finance.yahoo.com/>you can...
Thanks, Randy, but that's not the problem. The actual code had Cells(2,1) and EndDate defined properly (I merely inserted the definitions in the posting to cut...
The problem seems to be with the ^IRX data. If I substitute another index, say ^VIX, the coding works just fine. Any idea as to how to fix this? ... From:...
When I ran the code using the date assignments, it ran fine for me. That is, I ran this module: Sub Test() Dim StartYear As Integer Dim StartMonth As Integer ...
Aha! I recall what the issue is now -- it arose a few weeks ago. You need to get the latest version of 2.0k from the "Works in Progress" folder. See this...
This is really bizarre. I copied your code fragment below exactly and ran it exactly as you did but I got the results I mentioned previously, the first few...
Is it possible to download a specific minute with the SMF Add-in? For example, I would like to get close for 9:35 AM; I currently am getting open, but have to...
More than likely, it's possible. I don't know of a source, though, since I don't use real-time or intraday data. One of my goals is to make fewer decisions,...
Hello Randy, thanks for your reply. I managed to get to step 4 after installing 2.0k version of the add-in. I tried complete formula you posted first, but i...
Sorry for the prevoius post, i got it to work in ittereations, only complete formula does not work yet. Will try to see how to fix that. Thanks a lot Igor...
That's an uncalled for comment Randy is a tireless worker for all of us and he deserves nothing short of your full respect. His comment was a simple statement...
03/01/2010 Hi All, This link use to be amazing but now it doesn't work like it use to anymore. It would be great to use this link again to look at 10 years...
Anybody having trouble in Excel 2003 with retrieving yield data from Yahoo? I am using Yahoo Finance tag "y" for yield in my array formula. The data is there...
That's how they generate the data. If the yield is 2.52%, they send 2.52 (without the percentage, because they're giving you the percentage yield). If you...
I have a list of municipal and corporate bonds for which I want to pull price quotes, etc. This information can generally be found on Fidelity, Schwab, you...
Unless the information is available on public pages, I won't be able to give much assistance, since I can't look at the coding of the web page to see how the...
Hi all - I've been using the add-in for years, mainly for GetYahooHistory purposes and it has been great. I have also used the GetElementNumber functions...
