The only way I know of would be to grab the unadjusted closing price and adjust it yourself with the applicable splits. You could get the splits from a webrharmelink
Try visiting the web pages under the EXCEL Web Query dialog (keyboard shortcut alt+d+d+w). It could be that the websites are redirecting you to some web page.rharmelink
How can I get the split adjusted but not dividend adjusted closing price on a specific date for a stock? The smfPricesByDates() function retrieves the "Adj.gotsaurabh
For the Add-in, Documentation, Templates, Tips and FAQs, visit http://ogres-crypt.com/SMF
The add-in is maintained using EXCEL 2007 under a Vista operating system using U.S. regional settings, so other platforms and/or versions may have issues. No Mac. No Open Office.
If you're reporting a problem, remember that I'm not a mind reader -- "It doesn't work right" is not a helpful description of a problem. Please try to include relevant information, such as:
-- The specific function(s) or template(s) you are having problems with.
-- The parameter(s) you are using with the function(s).
-- The version of EXCEL you use.
-- The operating system you're running EXCEL under.
-- The steps you took to try to resolve the problem.
-- The ticker symbols or URLs that are being used.
-- The results you expect to get and what you actually get.
Note that emails sent directly to me typically end up in my SPAM folder and never get read, so send your questions and issues to this Yahoo group.
- Jun 18, 2006
- This is a public group.
- Attachments are permitted.
- Members cannot hide email address.
- Listed in Yahoo Groups directory.
- Membership does not require approval.
- Messages from new members require approval.
- All members can post messages.