Skip to search.

Breaking News Visit Yahoo! News for the latest.

×Close this window

smf_addin · EXCEL Stock Market Functions Add-in

The Yahoo! Groups Product Blog

Check it out!

Group Information

  • Members: 22737
  • Category: Software
  • Founded: Jun 18, 2006
  • Language: English
? Already a member? Sign in to Yahoo!

Yahoo! Groups Tips

Did you know...
Hear how Yahoo! Groups has changed the lives of others. Take me there.

Messages

Advanced
Messages Help
Messages 18723 - 18752 of 22361   Oldest  |  < Older  |  Newer >  |  Newest
Messages: Simplify | Expand Author Sort by Date ^
18723 Randy Harmelink
rharmelink Send Email
May 24, 2012
8:57 pm
Sounds like a problem in your downloading process. For FireFox, it usually ends up in the default "Download"; folder. You can download the ZIP archive anywhere...
18724 ddbohrer Send Email May 24, 2012
11:33 pm
So for the add-in to work it does not have to reside in the c:\programs file\smf add-in\ folder...
18725 Randy Harmelink
rharmelink Send Email
May 25, 2012
12:39 am
Correct. You can locate the add-in almost any where. HOWEVER, if you open up a workbook that was saved with the add-in in a different location, you'll end up...
18726 sando2067 Send Email May 25, 2012
12:43 am
I've been following the changes and the May 10 file did seem to work for awhile. The fix seems to be broken again ... thanks MSN. i.e. entry #25, "Last Price"...
18727 Randy Harmelink
rharmelink Send Email
May 25, 2012
12:56 am
"Last Price" is not retrieved from the "stock-price" page, but from the "stock-report" page: ...
18728 rebalance85 Send Email May 25, 2012
1:00 am
http://cn.advfn.com/p.php?pid=financials&btn=annual_reports&mode=&symbol=NYSE%3AIBM Now works well in Excel 2007, but IBM is still error. I check the URL, it...
18729 Randy Harmelink
rharmelink Send Email
May 25, 2012
1:03 am
If you JUST use "IBM" as the ticker symbol, your domain assumes it is the one on the London Stock Exchange, which has no web pages for quarterly and annual...
18730 rebalance85 Send Email May 25, 2012
1:23 am
Yes. I check three tickers: IBM: NYSE/LSE; ANV: AMEX/TSE; CYAN: NASDAQ/LSE. So, if it's possible help me to update the template, correct the ticker as:...
18731 Clark F. Grain
cgrain76 Send Email
May 25, 2012
2:15 am
Hello all, I am not sure about what you are trying to accomplish. I think you are interested in downloading financial data, for specific companies, in order...
18732 rebalance85 Send Email May 25, 2012
3:01 am
Thank you very much for your kindess. We want to have 10 years financial statments, the goal is the same, find, analysis, buy and sell. I want to put some tab...
18733 bobc94595 Send Email May 25, 2012
5:06 am
Randy, I have extracted the files within Works In Progress created on April 7,2012, "RCH_Stock_Market_Functions-2.1.2012.04.07.zip" to the following location...
18734 Randy Harmelink
rharmelink Send Email
May 25, 2012
5:37 am
I know nothing about Win7 or EXCEL 2010. On Vista, I would just tell FireFox to download the file, and then drag and drop it into the folder from where it was...
18735 rebalance85 Send Email May 25, 2012
6:35 am
What should I do? How to change the ticker as: NYSE:IBM?...
18736 Randy Harmelink
rharmelink Send Email
May 25, 2012
6:49 am
Just use it as your ticker symbol when accessing AdvFN data. I think you're going to need to use the exchange for all ticker symbols, since you don't know what...
18737 manan_atit Send Email May 25, 2012
1:43 pm
Hi - THanks for a fantastic tool. I've learn a lot from the folks that post. Was wondering if there was a website or field that pulls Proforma EPS numbers? ...
18738 Clark F. Grain
cgrain76 Send Email
May 25, 2012
1:46 pm
I forgot to give instructions. Open the Start tab and type in the stock symbol in the upper left cell (Blue) press enter and wait about 30 seconds or so for...
18739 Randy Harmelink
rharmelink Send Email
May 25, 2012
1:55 pm
I don't even know what that would be......
18740 Juan
juangecko Send Email
May 25, 2012
4:04 pm
hello, i would like to know if it is possible to get the market cap for a specific date for a US stock. I am able to do it for the price......
18741 Jim
buckleca Send Email
May 25, 2012
4:07 pm
I'm using smfStrExtr to extract what I need from the search. The search finds: "45201020 - Communications Equipment" I'd like to extract "Communications...
18742 Randy Harmelink
rharmelink Send Email
May 25, 2012
4:09 pm
You would need to create it yourself by retrieving the price that way, but you would also need to get the number of shares from another source -- which isn't...
18743 Randy Harmelink
rharmelink Send Email
May 25, 2012
4:13 pm
The technique I use is to append a dummy string value to the end (or to the beginning if I need something there). I usually use "|" because it's not typically...
18744 Juan
juangecko Send Email
May 25, 2012
4:30 pm
Thanks Randy for your quick reply. i would only need the number of shares of their latest earnings report. also what the formula to get today's outstanding...
18745 Jim
buckleca Send Email
May 25, 2012
4:30 pm
Ingenious guy you are! In my formula: =+smfstrextr(GetNameExSW(+$A8,"c","Sector",2)& "|", "- ","|") returns: "Communications Equipment" Many Thanks...
18746 Randy Harmelink
rharmelink Send Email
May 25, 2012
4:33 pm
Check the list of elements that came with the add-in. There are a few choices, so I'm not sure which number of shares would be the appropriate one to use....
18747 Lucky Pierre
pierre_powell Send Email
May 25, 2012
5:32 pm
My excel (2010) will no longer pull down certain numbers. For example, the rchgetelementnumber function won't pull company name, dividends from msn or other...
18748 Randy Harmelink
rharmelink Send Email
May 25, 2012
5:33 pm
See: http://finance.groups.yahoo.com/group/smf_addin/message/18529...
18749 Lucky Pierre
pierre_powell Send Email
May 25, 2012
5:47 pm
Thanks Randy, I updated this file with no avail. I am also having problems bringing down from non-msn sites. I reinstalled and seem to be stuck. The...
18750 Malcolm
malcolmdlphi... Send Email
May 25, 2012
6:07 pm
Is there an explanation somewhere of how the SMF functions work? I am wondering if they can be ported to Perl or other scripting language. Does anyone know if...
18751 Randy Harmelink
rharmelink Send Email
May 25, 2012
6:13 pm
All of those element numbers are working fine here for ticker MMM. Only 989 is non-MSN. What do you get for: =RCHGetElementNumber("Version&quot;) ...
18752 Randy Harmelink
rharmelink Send Email
May 25, 2012
6:14 pm
The VBA code is open source, so that would be how they work....
Messages 18723 - 18752 of 22361   Oldest  |  < Older  |  Newer >  |  Newest
Add to My Yahoo!      XML What's This?

Copyright © 2010 Yahoo! Inc. All rights reserved.
Privacy Policy - Terms of Service - Guidelines NEW - Help