What is the difference between "Adjusted Closing Price" for something and the last price ? Do closing prices get adjusted after the fact ? Please explain....
5959
Randy Harmelink
rharmelink
Feb 1, 2009 10:13 pm
According to Yahoo, the "adjusted closing price" is the "Close price adjusted for dividends and splits."...
5960
timvks
Feb 2, 2009 5:06 am
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...
5961
Randy Harmelink
rharmelink
Feb 2, 2009 5:08 am
You can override that processing by using pDim1 and pDim2. A recent example from the message archive: ...
5962
timvks
Feb 2, 2009 5:47 am
... works great, thanks!...
5963
alagalah
Feb 2, 2009 11:29 pm
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...
5964
Randy Harmelink
rharmelink
Feb 3, 2009 12:49 am
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...
5965
alagalah
Feb 3, 2009 2:00 am
Thanks! Will keep an eye on it... would you say Morningstar or Reuters are the most reliable ? ... Google ... to ... they ... the ... appropriate ... ...
5966
Randy Harmelink
rharmelink
Feb 3, 2009 2:56 am
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,...
5967
Frank C Presson III
fpresson
Feb 3, 2009 3:32 am
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...
5968
Ronald McEwan
ronmac17
Feb 3, 2009 5:33 am
http://www.investmentnews.com/apps/pbcs.dll/article?AID=/20090202/REG/902029989/1094/INDaily01 Beginning as early as May 2008, Morningstar began “screen...
5969
Mark Simms
msimmsx
Feb 3, 2009 8:39 pm
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...
5970
bigzippy
Feb 3, 2009 10:11 pm
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...
5971
Randy Harmelink
rharmelink
Feb 3, 2009 10:28 pm
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...
5972
jagonzbe@...
jagonzbe
Feb 4, 2009 6:36 pm
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...
5973
Randy Harmelink
rharmelink
Feb 4, 2009 6:37 pm
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...
5974
jagonzbe@...
jagonzbe
Feb 4, 2009 7:27 pm
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...
5975
jagonzbe@...
jagonzbe
Feb 4, 2009 7:41 pm
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;...
5976
Randy Harmelink
rharmelink
Feb 4, 2009 8:30 pm
Getting the add-in to work in the workbook and in the VBA project does require two separate processes. They are independent settings....
5977
Randy Harmelink
rharmelink
Feb 4, 2009 8:35 pm
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...
5978
jagonzbe@...
jagonzbe
Feb 4, 2009 9:08 pm
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...
5979
jagonzb
Feb 5, 2009 4:55 pm
Hello, The "Obsolete Documentation" folder contains: 2.1 - RCHGetElementNumber Element List.html List of element numbers available for the...
5980
Randy Harmelink
rharmelink
Feb 5, 2009 5:04 pm
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...
5981
jagonzbe@...
jagonzbe
Feb 5, 2009 6:07 pm
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 ...
5982
cindercone21
Feb 6, 2009 11:26 pm
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...
5983
Randy Harmelink
rharmelink
Feb 6, 2009 11:38 pm
The only thing I can think of is to supplement it with the current day's data. Say, using RCHGetYahooQuotes()....
5984
thegraphicplace
Feb 7, 2009 2:05 pm
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...
5985
thegraphicplace
Feb 7, 2009 3:22 pm
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...
5986
Randy Harmelink
rharmelink
Feb 7, 2009 4:06 pm
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...
5987
thegraphicplace
Feb 8, 2009 7:42 pm
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...
