Hi:  Does anyone know where I can download free historical price data on options or a site that provides historical option price charts? I used to get...
7813
Gabriele Sorbara
g_sorbara
Nov 1, 2009 6:54 pm
Hi, I actually did find the charts on MarketWatch again (see link pasted below). For the five letter option ticker you need to put an equals signs after the...
7814
Gabriele Sorbara
g_sorbara
Nov 1, 2009 7:03 pm
Sorry for all the e-mails, but want to clarify that the yahoo stock ticker charts were created with the rchcreatecomment() function, which pulled the charts...
7815
fincoolio
Nov 1, 2009 8:45 pm
Hey Randy, I spent some time trying to update the source URLs for the motley fool caps website, but I couldn't figure it out. Are you able to? Thanks for...
7816
Randy Harmelink
rharmelink
Nov 1, 2009 9:12 pm
They've completely redone the page. However, if you add the modGetTagContent.bas module from the "Works In Progress" folder from the group's file area to your...
7817
Randy Harmelink
rharmelink
Nov 1, 2009 9:30 pm
You could try OptionsXpress, but it only has O/H/L/C and not closing bid/ask prices (which I consider a necessity). For example: ...
7818
kivikatz
Nov 2, 2009 3:43 am
Is there any way to model what-if scenarios for options with SMF add-in? For instance, I would like to determine what would happen to a given option symbol...
7819
carmine288
Nov 2, 2009 4:29 am
I the following: =RCHGetTableCell("http://online.wsj.com/mdc/public/page/2_3021-tradingdi\ ary-20081001.html?mod=mdc_pastcalendar#nysevolB",2,">Nasdaq",,,,1 ...
7820
Randy Harmelink
rharmelink
Nov 2, 2009 4:43 am
If your serial date value is in cell C3: =RCHGetTableCell("http://online.wsj.com/mdc/public/page/2_3021-tradingdiary- "&TEXT(C3,"yyyymmdd")&".html", ...
7821
g_sorbara
Nov 2, 2009 12:48 pm
Thanks, you're the man!...
7822
fincoolio
Nov 2, 2009 12:52 pm
Hi Randy, thanks so much for this. The first tag works =VALUE(RCHGetWebData("http://caps.fool.com/Ticker/"&C$2&".aspx","stars-lg.gif",1,-1)) But the other tags...
7823
g_sorbara
Nov 2, 2009 1:06 pm
I uploaded my my excel file in the uploads section of this group. Can you help me with linking the tickers to the formula. I would also like the image to...
7824
raj sekhar
sekhraja
Nov 2, 2009 1:39 pm
Hi dear groups members, Â Need info on RCHGetTable software and its add-ons'Â and how it works on indian stock Exchanges' stocks and MCX, pls send the...
7825
Randy Harmelink
rharmelink
Nov 2, 2009 1:44 pm
It sounds like you imported the .bas file into the workbook's VBA project instead of modifying the add-in code? You could do it that way, but then the...
7826
Randy Harmelink
rharmelink
Nov 2, 2009 1:50 pm
Try this in cell C3: =RCHCreateComment("http://bigcharts.marketwatch.com/charts/big.chart?symb= "&A3&"="&B3&";&type=2&style=320&time=4&freq=1&nosettings=1",99) ...
7827
Randy Harmelink
rharmelink
Nov 2, 2009 1:52 pm
Go to the "Documentation" folder of the files area of the group. There are a number of details available there....
7828
g_sorbara
Nov 2, 2009 2:30 pm
Bravo! Thanks so much!...
7829
hdevoto
Nov 2, 2009 6:25 pm
hi, i am using smfGetMSNHistory to retrieve data from msn but i only get about 250 rows regardless of the time period i entered. is there a way to get data for...
7830
Randy Harmelink
rharmelink
Nov 2, 2009 8:29 pm
MSN has changed their parameters several times since I originally wrote that function. For now, try something like this instead: =smfGetCSVFile(" ...
7831
kitiany
Nov 2, 2009 8:30 pm
Randy, Does the formula only attach PNG graphics into the comment box? I was trying to modify your code to create a comment that showed a table of the top 10...
7832
Randy Harmelink
rharmelink
Nov 2, 2009 8:51 pm
This: =RCHCreateComment("",0,,,,,,,"xxx","") ...would load text of "xxx" into the comment. The hard part will be formatting such a list to make it readable....
7833
hdevoto
Nov 2, 2009 10:23 pm
thanks for the help. i did not test it extensively but i think the following changes to the function makes it work. hope it helps. ...
7834
Randy Harmelink
rharmelink
Nov 2, 2009 10:55 pm
Thanks. That was the simplest change I could consider -- but I think I'd prefer to pass the starting day and ending day, or default the ending month to the ...
7835
Bozwood
Nov 3, 2009 12:34 am
I am now getting 'error' for the RCHGetElementNumber functions on both annual and quarterly basis when using AdvFN. Has anyone else seen this? Also, I am able...
7836
Randy Harmelink
rharmelink
Nov 3, 2009 1:17 am
I'll need more details. I just tried ticker MMM with the AdvFN-Data-Dump-3.xls workbook from the files area for both quarterly and annual data and had no...
7837
Bozwood
Nov 3, 2009 2:03 am
tried MMM as well and still getting the 'error' message. must be something with my machine. any ideas as to how to correct? it seems odd that some would work...
7838
Randy Harmelink
rharmelink
Nov 3, 2009 2:18 am
What formulas are in the cells you are getting "Error" with? Do you still get the "Error" returned if you type in the formula in a new workbook, or is this...
7839
Pete
petekoch
Nov 3, 2009 2:35 am
I opened a sheet and get 'error' for all the ADVFN elements, but all others working OK. Might be a temporary glitch with ADVFN....
7840
timdbui
Nov 3, 2009 3:40 am
Hi Randy, I have a spreadsheet that uses RCHGetElementnumber. It works fine this morning, but now most of the cells have "Error". Even simple cell like this...
7841
Randy H
rharmelink
Nov 3, 2009 4:27 am
With more details on recent AdvFN errors for me to look at, it now appears that AdvFN has made some changes to their website. I don't know if this is a...
