Stock Price from 1 month, 3 months and 12 months Ago

[ssmd64]

Hi Excel Forum,

I use Excel 365 and am aware of the capacity to place the current stock price, 52 week High and Low, which I use frequently and greatly appreciate. However, I need rows of data which also include the price of a stock (say, MSFT) from 30 days prior to today's price, 3 months prior to today's price and 12 months prior to today's price. Is this possible to obtain quickly and expeditiously?

The first worksheet in the attached workbook has two rows of information on two stocks, the price data of which was culled from Excel 365's current stock price function. Columns G and H are where I'd like the stock price from the prior 30 days and 90 days, respectively, to go. Each day, the price from the prior 30 days, 90 days and 12 months shall be updated. I haven't determined where the 12 month prior stock price shall go yet.

Can you please walk me through the steps? Thank you for any help. Am happy to pay whatever is considered fair for the capacity to have this data.

I posted on different board also, because this problem probably does not have a single solution, Excel 365 behaves differently than the non-365 version and it is not clear to me that what I require can be done in 365. Any solution will require extra cost and consultation fees, which I am happy to pay.

[Pepe Le Mokko]

Administrative note

Welcome to the forum

in your haste to solve your problem, you probably missed the yellow banner advising how to get answers faster by posting a sheet ?

Please take a moment to read it and attach a sheet accordingly.

Thanks you for helping us help you

[ssmd64]

Thank you for your reply. I've added the worksheet with a brief description in the initial inquiry.

[alansidman]

Look at this link and determine if it is useful for your situation--> http://investexcel.net/multiple-stoc...#comment-48965

[alansidman]

crossposted: https://www.ozgrid.com/forum/index.p...o/#post1232729

Rule 03: Cross-posting Without Telling Us

Your post does not comply with Rule 3 of our Forum RULES. Do not cross-post your question on multiple forums without telling us about your threads on other forums.

Post a link to any other forums where you have asked the same question.

Cross-posting is when you post the same question in other forums on the web. The last thing you want to do is waste people's time working on an issue you have already resolved elsewhere. We prefer that you not cross-post at all, but if you do (and it's unlikely to go unnoticed), you MUST provide a link (copy the url from the address bar in your browser) to the cross-post.

Read this to understand why we ask you to do this.

I have added the crosspost reference for you today. Please comply with this and all our rules in the future

[ssmd64]

Thank you for your response. Yes, I'm open to using something that downloads a stream of quotes for a given stock symbol. The difficulty with applying this is twofold: I'll ultimately be examining rows of at least 100 to 150 separate stock symbols each day, and each day the prior 1 month, 3 month and 12 month will need to change by one day.

[ssmd64]

I posted on different board pertaining to VBA because this problem does not have a single solution, Excel 365 behaves differently than the non-365 version and it is not clear to me that what I require can be done in 365. Any solution will require extra cost and consultation fees, which I am happy to pay. I will addend my initial post, though.

[alansidman]

Did you read this: https://www.excelguru.ca/content.php?184 which was listed in my previous post. We take crossposting seriously on this forum as well as do other forums. Please comply and post all locations you may have posted this issue if more than the one I indicated.

[ssmd64]

Just delete my inquiry. I'll hire someone locally to address my Excel problem.