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...
9502
Randy Harmelink
rharmelink
Mar 3, 2010 6:18 pm
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...
9501
tbrown92282
Mar 3, 2010 4:10 pm
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...
9500
Randy Harmelink
rharmelink
Mar 2, 2010 11:29 pm
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...
9499
ecwmba@...
ecwmba...
Mar 2, 2010 10:35 pm
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...
9498
Randy Harmelink
rharmelink
Mar 2, 2010 3:07 pm
It stopped working in November when AdvFN updated their website so that the PHP routine could no longer grab data from their site....
9497
zefiro401k
Mar 2, 2010 2:17 pm
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...
9496
Gary Stein
garyestein1973
Mar 2, 2010 12:35 pm
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...
9495
bagzigingahouse
Mar 2, 2010 9:32 am
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...
9494
bagzigingahouse
Mar 2, 2010 8:48 am
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...
9493
powerlytix
Mar 2, 2010 7:04 am
if another goal is to be obtuse you should have a great year...
9492
Randy Harmelink
rharmelink
Mar 1, 2010 11:13 pm
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,...
9491
powerlytix
Mar 1, 2010 10:54 pm
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...
9490
Lew Glenn
lewglenn
Mar 1, 2010 7:08 pm
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...
9489
Lew Glenn
lewglenn
Mar 1, 2010 7:02 pm
That did it! Thanks again. ... From: Randy Harmelink <rharmelink@...> Subject: Re: [smf_addin] Problem with RCHGetYahooHistory To:...
9488
Lew Glenn
lewglenn
Mar 1, 2010 6:43 pm
Great, thanks! I'll try that right away. ... From: Randy Harmelink <rharmelink@...> Subject: Re: [smf_addin] Problem with RCHGetYahooHistory To:...
9487
Randy Harmelink
rharmelink
Mar 1, 2010 6:38 pm
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...
9486
Randy Harmelink
rharmelink
Mar 1, 2010 6:18 pm
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 ...
9485
Lew Glenn
lewglenn
Mar 1, 2010 6:05 pm
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:...
9484
Lew Glenn
lewglenn
Mar 1, 2010 5:18 pm
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...
9483
paul messerschmidt
fuelspotpaul
Mar 1, 2010 3:51 pm
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...
9482
Randy Harmelink
rharmelink
Mar 1, 2010 3:33 pm
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 ...
9481
Randy Harmelink
rharmelink
Mar 1, 2010 3:25 pm
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...
9480
bagzigingahouse
Mar 1, 2010 2:02 pm
FTSE=^FTSE CAC40=^FCHI DAX=^GDAXI IBEX=^IBEX...
9479
Yang Dapeng
roctripod
Mar 1, 2010 1:48 pm
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]...
9478
Kario Tyrer
kariotyrer
Mar 1, 2010 12:47 pm
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...
9477
Randy Harmelink
rharmelink
Mar 1, 2010 12:37 pm
If you have version 2.0k of the add-in (see the "Works in Progress" folder of the files area), this new function: ...
9476
Randy Harmelink
rharmelink
Mar 1, 2010 12:20 pm
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...
9475
smithjhhic
Mar 1, 2010 10:44 am
Randy, The site you help me with previously (see below) just changed and move the symbol. The formula I have been using no longer works....
9474
bagzigingahouse
Mar 1, 2010 9:43 am
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...
