Stock Tracking Spreadsheet

**LouisDel** · 07-07-2015, 06:32 PM

Hi.

I have very little experience with this side of excel (and by that I mean I can input data manually and that's about it) and I need a fair amount of help.
I need a spreadsheet that not only constantly updates a few specific stock prices, which I do not know currently, but also at certain times of the day will save the stock price!

For example: The spreadsheet has a constantly updating (every minute or so) tracker of the eBay stock, and then on the left there are one hour intervals of the day (1AM, 2AM, 3AM) with the stock price as of that time being saved as soon as it hits that time, so every time it is 2AM it saves the stock price, and can do this 24 hours a day, all week.

Thank you very much for the help!

**humdingaling** · 07-08-2015, 01:12 AM

it is not very clear what you are asking help for

can you please be more concise in what you want people to help you with

it would probably be better if you attach a workbook with before and after to clarify your needs

**ashishmehra2010** · 07-08-2015, 04:21 AM

Originally Posted by LouisDel

Hi.

I have very little experience with this side of excel (and by that I mean I can input data manually and that's about it) and I need a fair amount of help.
I need a spreadsheet that not only constantly updates a few specific stock prices, which I do not know currently, but also at certain times of the day will save the stock price!

For example: The spreadsheet has a constantly updating (every minute or so) tracker of the eBay stock, and then on the left there are one hour intervals of the day (1AM, 2AM, 3AM) with the stock price as of that time being saved as soon as it hits that time, so every time it is 2AM it saves the stock price, and can do this 24 hours a day, all week.

Thank you very much for the help!

Hi,

Refer to the following link:

http://www.exceltip.com/stock-perfor...yco-gatus.html
http://www.exceltip.com/excel-dashboards

Check if these links can help you.

Regards,
AM