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...
Want your group to be featured on the Yahoo! Groups website? Add a group photo to Flickr.

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 5958 - 5987 of 7919   Oldest  |  < Older  |  Newer >  |  Newest
Messages: Simplify | Expand   (Group by Topic) Author Sort by Date ^
5958
What is the difference between "Adjusted Closing Price" for something and the last price ? Do closing prices get adjusted after the fact ? Please explain....
percyqsmith
Offline Send Email
Feb 1, 2009
8:19 pm
5959
According to Yahoo, the "adjusted closing price" is the "Close price adjusted for dividends and splits."...
Randy Harmelink
rharmelink
Offline Send Email
Feb 1, 2009
10:13 pm
5960
Has any of you ported the smfGetYahooHistory function to VBA? I want to use the function to get data and save it to mysql. It seems the function currently uses...
timvks
Offline Send Email
Feb 2, 2009
5:06 am
5961
You can override that processing by using pDim1 and pDim2. A recent example from the message archive: ...
Randy Harmelink
rharmelink
Offline Send Email
Feb 2, 2009
5:08 am
5962
... works great, thanks!...
timvks
Offline Send Email
Feb 2, 2009
5:47 am
5963
Sorry for the n00b question, but thought this would be an appropriate place to ask, since the AddIn relies on website data being accurate... When does...
alagalah
Offline Send Email
Feb 2, 2009
11:29 pm
5964
No real answer here. I think they each update when they update -- I would suspect usually anywhere from a few days to a week. For example, MMM announced on...
Randy Harmelink
rharmelink
Offline Send Email
Feb 3, 2009
12:49 am
5965
Thanks! Will keep an eye on it... would you say Morningstar or Reuters are the most reliable ? ... Google ... to ... they ... the ... appropriate ... ...
alagalah
Offline Send Email
Feb 3, 2009
2:00 am
5966
I usually avoid Morningstar because it needs the IE cookie in order for the add-in to access its data. Typically, I go with either MSN or Reuters. Or AdvFN,...
Randy Harmelink
rharmelink
Offline Send Email
Feb 3, 2009
2:56 am
5967
Thanks. I solved the problem by unchecking the box on the SMF add in that was set to the download file and browsed to the program/smf addin file set up in the...
Frank C Presson III
fpresson
Offline Send Email
Feb 3, 2009
3:32 am
5968
http://www.investmentnews.com/apps/pbcs.dll/article?AID=/20090202/REG/902029989/1094/INDaily01 Beginning as early as May 2008, Morningstar began “screen...
Ronald McEwan
ronmac17
Offline Send Email
Feb 3, 2009
5:33 am
5969
Silly case in two regards: 1) Morningstar is definitely lying: another company threatens them if they compete ? Wow, we are now into socialism. 2) If New...
Mark Simms
msimmsx
Offline Send Email
Feb 3, 2009
8:39 pm
5970
I use thomson one web site for research- it is password based I am trying to get the financial statement data from the site to excel and the problem is the...
bigzippy
Offline Send Email
Feb 3, 2009
10:11 pm
5971
If the data is being presented within a Java application, you usually need an API to access the data. I'm doubtful that you could use the add-in to access the...
Randy Harmelink
rharmelink
Offline Send Email
Feb 3, 2009
10:28 pm
5972
I tryed the code but I get a compile error "Sub or Function not defined" when it gets to the RCHGetYahooQuotes line; I included the RCH projects in the...
jagonzbe@...
jagonzbe
Offline Send Email
Feb 4, 2009
6:36 pm
5973
Not sure what to tell you? EXCEL version? Operating system? Add-in version? I only get the "Sub or Function not defined" error message if I haven't set the...
Randy Harmelink
rharmelink
Offline Send Email
Feb 4, 2009
6:37 pm
5974
I'm runing Excel 2007 /XP Professional; Addin was downloaded this morning; I tried the RCHGetTableCell formula in a Excel cell and worked fine... apparently...
jagonzbe@...
jagonzbe
Offline Send Email
Feb 4, 2009
7:27 pm
5975
I'm sorry Randy I missed part of your question... in the Object browser I selected <All Libraries> but I don't see the RCH_Stock_Market_Functions library;...
jagonzbe@...
jagonzbe
Offline Send Email
Feb 4, 2009
7:41 pm
5976
Getting the add-in to work in the workbook and in the VBA project does require two separate processes. They are independent settings....
Randy Harmelink
rharmelink
Offline Send Email
Feb 4, 2009
8:30 pm
5977
When in the object browser, if you have "All Libraries" selected, you should be able to find the add-in functions as members of the "<globals>" class. Or, look...
Randy Harmelink
rharmelink
Offline Send Email
Feb 4, 2009
8:35 pm
5978
I don't see the add-in functions under <globals> (I'm looking for names begining with RCH). In a previous mail I said that I had included the RCH projects in...
jagonzbe@...
jagonzbe
Offline Send Email
Feb 4, 2009
9:08 pm
5979
Hello, The "Obsolete Documentation" folder contains: 2.1 - RCHGetElementNumber Element List.html List of element numbers available for the...
jagonzb
Offline Send Email
Feb 5, 2009
4:55 pm
5980
An element list can be found in the XLS file that is distributed within the ZIP file that contains the add-in. Just look for it in the folder where you...
Randy Harmelink
rharmelink
Offline Send Email
Feb 5, 2009
5:04 pm
5981
Thank you Randy ... An element list can be found in the XLS file that is distributed within the ZIP file that contains the add-in. Just look for it in the ...
jagonzbe@...
jagonzbe
Offline Send Email
Feb 5, 2009
6:07 pm
5982
I have been using RCHGetYahooHistory and I love the ability to download this data to chart. But I have noticed that daily data is not updated until the...
cindercone21
Offline Send Email
Feb 6, 2009
11:26 pm
5983
The only thing I can think of is to supplement it with the current day's data. Say, using RCHGetYahooQuotes()....
Randy Harmelink
rharmelink
Offline Send Email
Feb 6, 2009
11:38 pm
5984
Hi, If you go look at the website yahoo history you will see that the data does not update until 8 or 9 at night. Hope that helps, Marilyn...
thegraphicplace
Offline Send Email
Feb 7, 2009
2:05 pm
5985
Hi again, I did a search on here and read some of the other peoples issue with this. I have been using the yahoo history add in for a loooong time now and all...
thegraphicplace
Offline Send Email
Feb 7, 2009
3:22 pm
5986
Is it possible there is another link somewhere in the workbook that is unrelated to the add-in? Because if the add-in link was the problem, the data shouldn't...
Randy Harmelink
rharmelink
Offline Send Email
Feb 7, 2009
4:06 pm
5987
Hi thank you for the response. There are no other links and when the message comes up if i click edit links it takes me to the smf add in. I uploaded the file...
thegraphicplace
Offline Send Email
Feb 8, 2009
7:42 pm
Messages 5958 - 5987 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