User Profile
Denham299
Copper Contributor
Joined 3 years ago
User Widgets
Recent Discussions
Re: International holiday dates confuse MS Stockhistory function
Detlef_Lewin Thank you. I was not clear with my question but your answer triggered another solution I will try. I was trying to using one row as a date row for a list of multi-country stocks. I now realize that that (likely) will not work as the date row will return the dates for that specific country/exchange. So I will have separate the stocks into countries and have separate date rows for each one (a drag but can't think of another way).1.6KViews0likes2CommentsInternational holiday dates confuse MS Stockhistory function
Hi. I am having trouble with a stock list to return prices that are traded on U.S., Canadian & European exchanges. The stockhistory function seems to adjust ONLY for U.S. holidays. E.g. U.S. Thanksgiving is not the same time as Canadian Thanksgiving. So my Canadian prices are not lining with the proper dates as the function skipped over Nov 24th as that was U.S. Thanksgiving. Any help you can provide on how to adjust the Stockhistory function to accommodate multiple closure dates for international in addition to U.S. stock exchanges closure dates please?1.7KViews0likes4Comments
Recent Blog Articles
No content to show