Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
IF statements with Dates
I'm trying to make a stock worksheet that gives me my stock data with a MS
Money web query. That works fine, what isn't working is, I have a worksheet called "Daily stocks" with dates starting in A3 and starts with todays date (todays date because I can't get my IF statement to work) and ends in 2009. I also have my stocks starting in B1 and ending in P1. Now to the problem On my daily stocks sheet I want the stocks to post automatically in on the date given and that works great. The stocks show up fine. The problem is, when the date changes to the next day, (say, April 27th) the stock quots in April 26 go blank or displays a 0. How can I make it so when the date changes the cells are left alone in the previous date cells? This is my formula: =IF(TODAY()=$A3,'Dons Stock'!$G$8,"") I want to copy that formula (or one that works) into all the cells down to 2009. But I want the previous date stocks to be left alone when the date changes to today, and the new stocks inserted for that day in that date. Any ideas would be grateful. Thanks. |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
IF statements with Dates
If seems to me you need to copy the data, rather than use an If statement. Why
not copy the data to the appropriate row where you are trying to store it? -- Regards, Fred "Excel_Headache" wrote in message ... I'm trying to make a stock worksheet that gives me my stock data with a MS Money web query. That works fine, what isn't working is, I have a worksheet called "Daily stocks" with dates starting in A3 and starts with today's date (today's date because I can't get my IF statement to work) and ends in 2009. I also have my stocks starting in B1 and ending in P1. Now to the problem On my daily stocks sheet I want the stocks to post automatically in on the date given and that works great. The stocks show up fine. The problem is, when the date changes to the next day, (say, April 27th) the stock quots in April 26 go blank or display's a 0. How can I make it so when the date changes the cells are left alone in the previous date cells? This is my formula: =IF(TODAY()=$A3,'Dons Stock'!$G$8,"") I want to copy that formula (or one that works) into all the cells down to 2009. But I want the previous date stocks to be left alone when the date changes to today, and the new stocks inserted for that day in that date. Any ideas would be grateful. Thanks. |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
IF statements with Dates
Thanks for the response, but what I would like it to do is update on its own
on each date. Keep the old data in the previous date and add new data in today's date. That way I can keep track of my daily stocks and make a graph without having to on a webpage to check. And I also don't want to have to do it manually. Its a simple request but difficult to do. "Fred Smith" wrote: If seems to me you need to copy the data, rather than use an If statement. Why not copy the data to the appropriate row where you are trying to store it? -- Regards, Fred "Excel_Headache" wrote in message ... I'm trying to make a stock worksheet that gives me my stock data with a MS Money web query. That works fine, what isn't working is, I have a worksheet called "Daily stocks" with dates starting in A3 and starts with today's date (today's date because I can't get my IF statement to work) and ends in 2009. I also have my stocks starting in B1 and ending in P1. Now to the problem On my daily stocks sheet I want the stocks to post automatically in on the date given and that works great. The stocks show up fine. The problem is, when the date changes to the next day, (say, April 27th) the stock quots in April 26 go blank or display's a 0. How can I make it so when the date changes the cells are left alone in the previous date cells? This is my formula: =IF(TODAY()=$A3,'Dons Stock'!$G$8,"") I want to copy that formula (or one that works) into all the cells down to 2009. But I want the previous date stocks to be left alone when the date changes to today, and the new stocks inserted for that day in that date. Any ideas would be grateful. Thanks. |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
IF statements with Dates
As powerful as Excel is, it isn't yet capable of 'updating on its own'.
When you're prepared to do some work, let us know. The solution won't be that difficult. There have to be thousands of people who keep track of stocks on a daily basis. -- Regards, Fred "Excel_Headache" wrote in message ... Thanks for the response, but what I would like it to do is update on its own on each date. Keep the old data in the previous date and add new data in today's date. That way I can keep track of my daily stocks and make a graph without having to on a webpage to check. And I also don't want to have to do it manually. It's a simple request but difficult to do. "Fred Smith" wrote: If seems to me you need to copy the data, rather than use an If statement. Why not copy the data to the appropriate row where you are trying to store it? -- Regards, Fred "Excel_Headache" wrote in message ... I'm trying to make a stock worksheet that gives me my stock data with a MS Money web query. That works fine, what isn't working is, I have a worksheet called "Daily stocks" with dates starting in A3 and starts with today's date (today's date because I can't get my IF statement to work) and ends in 2009. I also have my stocks starting in B1 and ending in P1. Now to the problem On my daily stocks sheet I want the stocks to post automatically in on the date given and that works great. The stocks show up fine. The problem is, when the date changes to the next day, (say, April 27th) the stock quots in April 26 go blank or display's a 0. How can I make it so when the date changes the cells are left alone in the previous date cells? This is my formula: =IF(TODAY()=$A3,'Dons Stock'!$G$8,"") I want to copy that formula (or one that works) into all the cells down to 2009. But I want the previous date stocks to be left alone when the date changes to today, and the new stocks inserted for that day in that date. Any ideas would be grateful. Thanks. |
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
IF statements with Dates
Wow, Fred, you win the Most ineffectual replies of the year award! I dont
want excel to update on its own, what I wanted was a formula to make it update on its own. But thank you for nothing. "Fred Smith" wrote: As powerful as Excel is, it isn't yet capable of 'updating on its own'. When you're prepared to do some work, let us know. The solution won't be that difficult. There have to be thousands of people who keep track of stocks on a daily basis. -- Regards, Fred "Excel_Headache" wrote in message ... Thanks for the response, but what I would like it to do is update on its own on each date. Keep the old data in the previous date and add new data in today's date. That way I can keep track of my daily stocks and make a graph without having to on a webpage to check. And I also don't want to have to do it manually. It's a simple request but difficult to do. "Fred Smith" wrote: If seems to me you need to copy the data, rather than use an If statement. Why not copy the data to the appropriate row where you are trying to store it? -- Regards, Fred "Excel_Headache" wrote in message ... I'm trying to make a stock worksheet that gives me my stock data with a MS Money web query. That works fine, what isn't working is, I have a worksheet called "Daily stocks" with dates starting in A3 and starts with today's date (today's date because I can't get my IF statement to work) and ends in 2009. I also have my stocks starting in B1 and ending in P1. Now to the problem On my daily stocks sheet I want the stocks to post automatically in on the date given and that works great. The stocks show up fine. The problem is, when the date changes to the next day, (say, April 27th) the stock quots in April 26 go blank or display's a 0. How can I make it so when the date changes the cells are left alone in the previous date cells? This is my formula: =IF(TODAY()=$A3,'Dons Stock'!$G$8,"") I want to copy that formula (or one that works) into all the cells down to 2009. But I want the previous date stocks to be left alone when the date changes to today, and the new stocks inserted for that day in that date. Any ideas would be grateful. Thanks. |
#6
Posted to microsoft.public.excel.misc
|
|||
|
|||
IF statements with Dates
Any time.
-- Regards, Fred "Excel_Headache" wrote in message ... Wow, Fred, you win the "Most ineffectual replies of the year" award! I don't want excel to 'update on its own,' what I wanted was a formula to make it update on its own. But thank you for nothing. "Fred Smith" wrote: As powerful as Excel is, it isn't yet capable of 'updating on its own'. When you're prepared to do some work, let us know. The solution won't be that difficult. There have to be thousands of people who keep track of stocks on a daily basis. -- Regards, Fred "Excel_Headache" wrote in message ... Thanks for the response, but what I would like it to do is update on its own on each date. Keep the old data in the previous date and add new data in today's date. That way I can keep track of my daily stocks and make a graph without having to on a webpage to check. And I also don't want to have to do it manually. It's a simple request but difficult to do. "Fred Smith" wrote: If seems to me you need to copy the data, rather than use an If statement. Why not copy the data to the appropriate row where you are trying to store it? -- Regards, Fred "Excel_Headache" wrote in message ... I'm trying to make a stock worksheet that gives me my stock data with a MS Money web query. That works fine, what isn't working is, I have a worksheet called "Daily stocks" with dates starting in A3 and starts with today's date (today's date because I can't get my IF statement to work) and ends in 2009. I also have my stocks starting in B1 and ending in P1. Now to the problem On my daily stocks sheet I want the stocks to post automatically in on the date given and that works great. The stocks show up fine. The problem is, when the date changes to the next day, (say, April 27th) the stock quots in April 26 go blank or display's a 0. How can I make it so when the date changes the cells are left alone in the previous date cells? This is my formula: =IF(TODAY()=$A3,'Dons Stock'!$G$8,"") I want to copy that formula (or one that works) into all the cells down to 2009. But I want the previous date stocks to be left alone when the date changes to today, and the new stocks inserted for that day in that date. Any ideas would be grateful. Thanks. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
If Statements with Dates | Excel Discussion (Misc queries) | |||
IF Statements (Mutliple Statements) | Excel Worksheet Functions | |||
If statements and Dates | New Users to Excel | |||
Dates in IF statements | Excel Discussion (Misc queries) | |||
if statements & dates? | Excel Worksheet Functions |