Hi Randy and others 1. I am interested in using this smfUpdateDownloadTable() function to avoid repeated / un necessary access to web pages 2. Tried searching...
18559
Randy Harmelink
rharmelink
May 12, 2012 1:41 pm
Check the "Links" area of the group. There are several items there....
18560
caninvestor_99
May 12, 2012 3:13 pm
... I have a similar issue after all programs on my laptop had to be reinstalled; the worksheet I am using "TD_Trend_Exhaustion_v3.xlsx" now has links errors...
18561
Randy Harmelink
rharmelink
May 12, 2012 3:15 pm
Turn off the sheet protection before doing the "Find and Replace All"?...
18562
rWarHol
May 13, 2012 7:42 am
Hello Randy, Sorry for the delay, Here is an example: Stock name BCE.TO RCHGetElementNumber("BCE.TO",13862) will return "Error" Other RCHGetElementNumber...
18563
Randy Harmelink
rharmelink
May 13, 2012 8:29 am
That's because BCE:TO is a Yahoo ticker symbol and element #13862 is from MSN. On MSN, the ticker symbol would be CA:BCE. Because of the way element #13862 is...
18564
rWarHol
May 14, 2012 2:09 am
Randy, It works fine now. Thanks a lot! Btw, I understand your explanation but I am a bit puzzled since I have used the library for quite a while (I think a...
18565
Randy Harmelink
rharmelink
May 14, 2012 2:21 am
It has to do with how the element is defined -- it can either be via saved parameters (for the RCHGetTableCell() function), or via a saved function (which...
18566
Subu S
mail_to_subu
May 15, 2012 7:15 pm
Dear Members - Thanks to various contributions and ideas here, I have a sp sheet to check cash flows of listed stock (lets call it the "cash flow" sheet). -...
18567
Randy Harmelink
rharmelink
May 15, 2012 8:33 pm
RCHGetYahooQuotes() can get current prices on up to 200 stocks in one Internet access....
18568
oyz79
May 16, 2012 3:56 am
I am trying to create a historical correlation matrix for multiple ETFs I have in an smf compatible spreadsheet. I have the daily closing price data importing...
18569
Randy Harmelink
rharmelink
May 16, 2012 4:10 am
I think all you would do is: =CORREL(adjusted_closing_prices_of_equity_1,adjusted_closing_prices_of_equity_2)...
18570
bagzigingahouse
May 16, 2012 9:58 am
Hello, i would kindly like to ask, if there is maybe a function among SMF that allows daily download from a csv file posted on the web? What i would like to do...
18571
Chirag Vyas
vyas.chirag
May 16, 2012 11:07 am
Is there anyway I can retrieve Japanese tickers earnings date into spreadsheet from earnings.com or any other site??...
18572
kerekoukin
May 16, 2012 11:25 am
I know this topic is old but if someone is looking here... is there a way to get more than 4 days 1 or 5 minutes data (like it is currently doing via the...
18573
Randy Harmelink
rharmelink
May 16, 2012 11:35 am
More details on the CBOE files please... Possibly the smfGetCSVFile() function could do the trick. On Wed, May 16, 2012 at 2:58 AM, bagzigingahouse...
18574
Randy Harmelink
rharmelink
May 16, 2012 11:36 am
I would need some examples. I have no idea of what a Japanese ticker symbol would be....
18575
bagzigingahouse
May 16, 2012 11:43 am
The files are contract months located here: http://cfe.cboe.com/Products/historicalVIX.aspx Each contract has its own file. Im going to review how the...
18576
Randy H
rharmelink
May 16, 2012 11:47 am
I see nothing under ticker symbol 2651 on Yahoo or earnings.com. On Wed, May 16, 2012 at 4:41 AM, Chirag Vyas <vyas.chirag@... ...
18577
Randy Harmelink
rharmelink
May 16, 2012 11:50 am
This appears to work just fine: =smfGetCSVFile(" http://cfe.cboe.com/Publish/ScheduledTask/MktData/datahouse/CFE_F13_VX.csv") On Wed, May 16, 2012 at 4:43 AM,...
18578
bagzigingahouse
May 16, 2012 12:07 pm
Randy, you are my God! It is working! Now if u could maybe give me a tip on how can i change the sort. Data on these files are starting from smaller to...
18579
Chirag Vyas
vyas.chirag
May 16, 2012 12:20 pm
Hi, sorry forgot to mention that we should add .T after every ticker in earnings.com. Yahoo do not keep Japanese tickers info IMO. 2651.T does the trick. Â ...
18580
bagzigingahouse
May 16, 2012 4:12 pm
Randy, i tried to open the file on the XP now, and the getCSV does not seem to work. My assumption is that the problem is the pop up message i get when trying...
18581
Randy Harmelink
rharmelink
May 16, 2012 5:22 pm
The popup message is from your browser. It should be bypassed when EXCEL asks for the file directly. Maybe you need to visit the site with IE or the EXCEL Web...
18582
Brent
bebentrim
May 16, 2012 5:29 pm
Anyone know if there is a way to grab historical market cap or simply shares outstanding for equities? If shares outstanding can be grabbed (by quarter) then I...
18583
bagzigingahouse
May 16, 2012 5:43 pm
Yea, but the problem is that i dont get the popup when using smf, only when clicking on the link itself. And not sure how to use the web query option for...
18584
Brent
bebentrim
May 16, 2012 5:56 pm
Actually, I got it using the advfin element, but what is FQ20 date?...
18585
Randy Harmelink
rharmelink
May 16, 2012 6:03 pm
You don't need to use the web query option to get the csv -- it just creates a cookie for the web site. You can just cancel out of the web query after visiting...
18586
Randy Harmelink
rharmelink
May 16, 2012 6:05 pm
There are separate elements for the dates...check the element listing file that came with the add-in ZIP archive. If you want more history, you should use the...
18587
Randy Harmelink
rharmelink
May 16, 2012 6:10 pm
If all you want is the latest date in the list from earnings.com: =RCHGetTableCell(" http://www.earnings.com/company.asp?client=cb&ticker=2651.t",7, ">Earnings...
