[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

Excel advise.....



PureBytes Links

Trading Reference Links

<x-html><!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<HTML><HEAD>
<META content="text/html; charset=iso-8859-1" http-equiv=Content-Type>
<META content="MSHTML 5.00.2314.1000" name=GENERATOR>
<STYLE></STYLE>
</HEAD>
<BODY bgColor=#ffffff>
<DIV><FONT face=Arial size=2>Hi guys,</FONT></DIV>
<DIV><FONT face=Arial size=2>&nbsp;&nbsp; This is my first spreadsheet, so I 
need some help.</FONT></DIV>
<DIV><FONT face=Arial size=2>Below is a picture of my program, I manually insert 
the highs,lows, and </FONT></DIV>
<DIV><FONT face=Arial size=2>close for days 1-4 (white cells). It then gives me 
calculations for day 5</FONT></DIV>
<DIV><FONT face=Arial size=2>(in gray cells).&nbsp; I have figured out how to 
import my ASCII text file into </FONT></DIV>
<DIV><FONT face=Arial size=2>Excel but what do I need to do from 
there?</FONT></DIV>
<DIV>&nbsp;</DIV>
<DIV><FONT face=Arial size=2>1.&nbsp; Since I will update the data each day, and 
the first&nbsp;row is the oldest date...</FONT></DIV>
<DIV><FONT face=Arial size=2>how do I program excel to use the</FONT><FONT 
face=Arial size=2> LAST entry of each column? </FONT></DIV>
<DIV>&nbsp;</DIV>
<DIV><FONT face=Arial size=2>2. Should I add another sheet for each ASCII text I 
import, or is there a </FONT></DIV>
<DIV><FONT face=Arial size=2>better/preferred method of managing the 
data?</FONT></DIV>
<DIV>&nbsp;</DIV>
<DIV><FONT face=Arial size=2>Thanks in advance,</FONT></DIV>
<DIV>&nbsp;</DIV>
<DIV><FONT face=Arial size=2>&nbsp;&nbsp;&nbsp;&nbsp; Adam Hefner</FONT></DIV>
<DIV>&nbsp;</DIV>
<DIV><IMG align=baseline alt="" border=0 hspace=0 
src="cid:001101bf71ed$20b0aaa0$786fa8c0@xxxxx";></DIV>
<DIV>&nbsp;</DIV></BODY></HTML>
</x-html>
Attachment Converted: "f:\eudora\attach\snap34.gif"