Hello, This email message is a notification to let you know that a file has been uploaded to the Files area of the smf_addin group. File : /Uploads by...
smf_addin@yahoogroups...
Nov 23, 2009 2:43 pm
8100
I just uploaded a sheet named Altman_Piotroski.xls. The sheet calculates both the Altman Z-Score and the Piotroski number for a given security. Being a...
Hi Randy, ... That is great and good enough for me. I am enclosing a spread sheet that still shows the lower numbers. I have tested it in two environments....
Wow. Unbelievable! The problem? You have trailing blanks on your ticker symbols. I've even tried it in the browser, and using a ticker symbol with a...
Trailing blanks are also generally an issue with GetTableCell. If your search string is, e.g., "Daily Volume", but the actual value on the page is "bDaily...
Hi Randy, ... Thank you, thank you and thank you. It would have taken me a while to figure that one out. I have tried the new 2.07k and it works beautimus....
Thanks, but a donation to a worthy charitable cause would be enough for me -- Cancer, Diabetes, Parkinson's, etc. By the way, have you noticed if your workbook...
Hi All Just recently upgraded to Excel2007 and discovered that the number of columns has increased from 256 (Column IV) to 16384 (Column XFD). The only...
Not having a problem here. I just put this formula in cell JX41: =RCHGetElementNumber("MMM",941) ...and it worked fine for me. As did this just below that: ...
Just moved my link to C:\SMF as directed by "Old School Value" (out of the "Program Files Folder") Now all cells are #NAME? Whats up? By the way Randy, you...
Randy, Is there a simple way out to get any of the two headers from http://in.reuters.com/money/quotes/companyProfile?symbol=ABG.BO which includes the company...
I tried to use smf_addin on Office 2010 64 bit but it crashes every time it accesses the Internet. My other spreadsheets don't have the same problem. Could...
while I know that most of the group is into stocks and funds, there are those of us out there that might be a little bit older and have a larger focus on bond...
Do you have any preferred sources of the data (i.e sample URLs)? The RCHGetTableCell() function may be able to grab the data from there. I don't know if this...
Hi guys, My name is rangga, i'm a new member of this group. I have a question, how can i find daily stock prices for public companies, whose stock is no longer...
Rangga Valbury
rangga_valbury@...
Nov 24, 2009 3:47 pm
8117
I will probably being using the FINRA or InvestinginBonds. I have yet to use the RCHGetTableCell(), so looks like I will be soon. The site you sent is only...
I'm not aware of a free source. If you do a Google search on: historical stock prices delisted ...you should find a number of pay services. I've not used any...
thanks Randy for your quick response, I expect your addins can solve my problem. Yup i think no free service out there.. thanks anyway.. rangga ... From: Randy...
Rangga Valbury
rangga_valbury@...
Nov 24, 2009 4:08 pm
8120
Hi:  I am trying to find a source where I can download real-time intra-day stock prices into Excel. Any suggestions? I also have Schwab, Fidelity and...
If you don't need a large quantity of them, there is a BATS template in the files area. Otherwise, I've been told that if you sign up for real-time quotes on...
Thanks for the quick response. I don't think I was clear though. I am looking to download minute by minute prices. Do you know the name of the "BATS...
Hello everyone. Thanks for all the valuable resources posted on/in this group. I am trying to get a hang of it. I would like to know if anyone may have insight...
Try: =smfGetTagContent("http://in.reuters.com/money/quotes/quote?symbol=ABG.BO","span",1,"Last Trade") At this point, it's just an experimental function I...
Having problems with message search?
Fill out this form to ensure your group is one of the first to be migrated to the new message search system.
