Search the web
Sign In
New User? Sign Up
smf_addin · EXCEL Stock Market Functions Add-in
? Already a member? Sign in to Yahoo!

Yahoo! Groups Tips

Did you know...
Real people. Real stories. See how Yahoo! Groups impacts members worldwide.

Best of Y! Groups

   Check them out and nominate your group.
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.

Messages

  Messages Help
Advanced
Messages 7890 - 7919 of 7919   Oldest  |  < Older  |  Newer >  |  Newest
Messages: Simplify | Expand   (Group by Topic) Author Sort by Date ^
7890
I found a table of "Ex Date" dates, if that's what you are referring to. This would return the date from the first row of the table, as an EXCEL serial date: ...
Randy Harmelink
rharmelink
Offline Send Email
Nov 7, 2009
8:42 pm
7891
Thanks! --gh...
garyhartling
Offline Send Email
Nov 7, 2009
9:10 pm
7892
Here is the link for the Flex Chart Signal http://stockcharts.com/def/servlet/SC.pnf?c=flex,P On the chart for Flex StockCharts shows a P&F Pattern: Ascending...
ronmac17
Offline Send Email
Nov 7, 2009
11:13 pm
7893
Unfortunately, what you're looking at is part of the image on that web page -- that's why the other items come from a different URL, where the items being...
Randy Harmelink
rharmelink
Offline Send Email
Nov 7, 2009
11:21 pm
7894
Thanks Randy, Is it possible to grab that chart with RCHCreateComment like you did in the SMF-Template-RCHCreateComment-Charts-Layout template?...
ronmac17
Offline Send Email
Nov 8, 2009
12:50 am
7895
Sorry, got it before I hit the send button for the previous reply. Choice = 2 Excellent!...
ronmac17
Offline Send Email
Nov 8, 2009
12:52 am
7896
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...
Send Email
Nov 8, 2009
8:55 pm
7897
Hi G_Sorbara, Thank you for your uploaded OptionsDetailsCharts. I like what I see and commend you for your efforts and willingness to share. I tried some ...
A_SEITER
tseiter2000
Offline Send Email
Nov 8, 2009
10:05 pm
7898
Tony:   Thanks for the compliments.  With regard to your first question, they do not auto populate, thus the tickers in blue need to be manually entered. ...
Gabriele Sorbara
g_sorbara
Offline Send Email
Nov 8, 2009
10:52 pm
7899
I have had your situation on both computers when I upgraded to Vista from XP. I think this is what finally worked in my situation. Download the program to the...
tannism
Offline Send Email
Nov 8, 2009
11:04 pm
7900
There was just a recent thread related to that, starting here: http://finance.groups.yahoo.com/group/smf_addin/message/7847 Two caveats: -- Some equities have...
Randy Harmelink
rharmelink
Offline Send Email
Nov 8, 2009
11:28 pm
7901
Thanks for the suggestion. Through some combination of opening blank sheets and installing/uninstalling and eventually moving the plug-in to a different...
Steve Lovisa
slovisa...
Offline Send Email
Nov 9, 2009
12:25 am
7902
not for me. are you sure?...
Bozwood
Offline Send Email
Nov 9, 2009
12:57 am
7903
It was working again for a day or so, but now seems to be off again. But the new beta process is still working....
Randy Harmelink
rharmelink
Offline Send Email
Nov 9, 2009
1:16 am
7904
Hi Gabe, Thanks for the info. My primary option strategy is to be a option writer and primarily covered ones. At time I will do some naked writes, but not...
A_SEITER
tseiter2000
Offline Send Email
Nov 9, 2009
4:11 am
7905 rexbloesser
Offline Send Email
Nov 9, 2009
11:38 am
7906
You can. I originally developed the add-in on Windows XP and EXCEL 2002. I bought a new machine last year and am now running with Vista and EXCEL 2007....
Randy Harmelink
rharmelink
Offline Send Email
Nov 9, 2009
2:35 pm
7907
On the rchgettablecell function, I get a blank cell returned for the following: ...
bebentrim
Offline Send Email
Nov 9, 2009
9:22 pm
7908
I have noticed on the =RCHGetTableCell fucntion, I cannot paste and copy more than 256 columns before I get a #VALUE! error that results in a #REF! error in...
bebentrim
Offline Send Email
Nov 9, 2009
9:25 pm
7909
I am trying to get a historical stock quote for a given stock symbol, lets say S, on a given day, lets say 10/21/09. can someone show me the formula I should...
ericthered1974
Offline Send Email
Nov 9, 2009
9:27 pm
7910
The problem is that the search string you are using appears in a previous spot on the page (i.e. "Top 1-Month Performers"). Try this instead: ...
Randy Harmelink
rharmelink
Offline Send Email
Nov 9, 2009
9:32 pm
7911
That sounds like an EXCEL issue instead of an add-in issue. If you can upload a copy of an example, I can take a look at it. But it would be difficult to...
Randy Harmelink
rharmelink
Offline Send Email
Nov 9, 2009
9:35 pm
7912
The easiest way would be to use smfPricesByDates: =smfPricesByDates("S",DATE(2009,10,21)) But it will return an adjusted closing price. You could get the...
Randy Harmelink
rharmelink
Offline Send Email
Nov 9, 2009
9:38 pm
7913
thank you.   what does the C indicate? and the 0?   Ken ... From: Randy Harmelink <rharmelink@...> Subject: Re: [smf_addin] RCH get yahoo history help ...
Ken W
ericthered1974
Offline Send Email
Nov 9, 2009
10:02 pm
7914
Check out the documentation for the function -- it's in the "Documentation" folder in the files area of the group....
Randy Harmelink
rharmelink
Offline Send Email
Nov 9, 2009
10:10 pm
7915
Hey, I am not able to get result for the RCHGetElementNumber() function. I am able to get the RCHGetYahooQuotes() to work. The formula that I have is...
keith_nunemaker
Offline Send Email
2:56 am
7916
See: http://finance.groups.yahoo.com/group/smf_addin/message/4918 I suspect RCHGetYahooQuotes() isn't actually working -- that you're seeing old values....
Randy Harmelink
rharmelink
Offline Send Email
3:02 am
7917
Randy To use getyahoohistory as an array formula for several dates is clear in your examples, but is there a way to use an array also for the symbols? I...
alles.klaro
Offline Send Email
4:42 am
7918
It wouldn't speed anything up, because the add-in would still need to do 500 queries against Yahoo's historical quotes database. Yahoo doesn't return history...
Randy Harmelink
rharmelink
Offline Send Email
5:21 am
7919
Hello Guys, i am getting an error that I have not had before in a spreadsheet which uses the SMF functions. I have not used this sheet for a few weeks but...
schlange.meister
schlange.mei...
Offline Send Email
9:32 am
Messages 7890 - 7919 of 7919   Oldest  |  < Older  |  Newer >  |  Newest
Advanced
Add to My Yahoo!      XML What's This?

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