|
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>Got everything from a couple of great people.
Life goes on.</FONT></DIV>
<DIV> </DIV>
<DIV style="FONT: 10pt arial">----- Original Message -----
<DIV style="BACKGROUND: #e4e4e4; font-color: black"><B>From:</B> <A
href="mailto:animal@xxxxxxxxx"; title=animal@xxxxxxxxx>Animal</A> </DIV>
<DIV><B>To:</B> <A href="mailto:realtraders@xxxxxxxxxxxxxxx";
title=realtraders@xxxxxxxxxxxxxxx>Realtraders</A> ; <A
href="mailto:metastock@xxxxxxxxxxxxx"; title=metastock@xxxxxxxxxxxxx>Metastock
User Group</A> </DIV>
<DIV><B>Sent:</B> Sunday, July 04, 1999 12:59 PM</DIV>
<DIV><B>Subject:</B> STKS/FUTR - Lost Day Prices - Help please</DIV></DIV>
<DIV><BR></DIV>
<DIV><FONT face=Arial size=2>Last week I set Metastock to download during my
absence. With my head focused on the planed backpack trip, I had a
major brain fart and missed setting the system to get the prices for Jul
1st. Need some help getting these.</FONT></DIV>
<DIV> </DIV></BODY></HTML>
</x-html>From ???@??? Mon Jul 05 20:59:53 1999
Return-Path: <majordom@xxxxxxxxxxxxxxxxxx>
Received: from listserv.equis.com (listserv.equis.com [204.246.137.2])
by purebytes.com (8.8.7/8.8.7) with ESMTP id RAA13518
for <neal@xxxxxxxxxxxxx>; Mon, 5 Jul 1999 17:03:44 -0700
Received: (from majordom@xxxxxxxxx)
by listserv.equis.com (8.8.7/8.8.7) id RAA31633
for metastock-outgoing; Mon, 5 Jul 1999 17:38:23 -0600
X-Authentication-Warning: listserv.equis.com: majordom set sender to owner-metastock@xxxxxxxxxxxxx using -f
Received: from freeze.metastock.com (freeze.metastock.com [204.246.137.5])
by listserv.equis.com (8.8.7/8.8.7) with ESMTP id RAA31630
for <metastock@xxxxxxxxxxxxxxxxxx>; Mon, 5 Jul 1999 17:38:20 -0600
Received: from smtp02.wxs.nl (smtp02.wxs.nl [195.121.6.60])
by freeze.metastock.com (8.8.5/8.8.5) with ESMTP id RAA17796
for <metastock@xxxxxxxxxxxxx>; Mon, 5 Jul 1999 17:53:40 -0600 (MDT)
Received: from escom ([195.121.181.224]) by smtp02.wxs.nl
(Netscape Messaging Server 3.61) with SMTP id AAB6BEB
for <metastock@xxxxxxxxxxxxx>; Tue, 6 Jul 1999 01:40:23 +0200
Message-ID: <006e01bec73f$4ed68020$e0b579c3@xxxxx>
From: "A.J. Maas" <anthmaas@xxxxxx>
To: <metastock@xxxxxxxxxxxxx>
References: <000501bec28d$5ce45e00$fdab7018@xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx>
Subject: Re: Off Topic: Excel function
Date: Tue, 6 Jul 1999 00:53:07 +0200
Organization: Ms-IRB
MIME-Version: 1.0
Content-Type: text/plain;
charset="iso-8859-1"
Content-Transfer-Encoding: 7bit
X-Priority: 3
X-MSMail-Priority: Normal
X-Mailer: Microsoft Outlook Express 5.00.2014.211
X-MimeOLE: Produced By Microsoft MimeOLE V5.00.2014.211
Sender: owner-metastock@xxxxxxxxxxxxx
Precedence: bulk
Reply-To: metastock@xxxxxxxxxxxxx
Status:
Simulantanously this will not work in Excel. But you can do so by using the sub (VBA).
WorkAround-1.
---------------------
Create a Macro (the Excel's program name for a VBA Module).
Eg, start out by recording one macro containing your manual steps that are required
to change 1 or 2 rows only. Name this your Test-Macro.
-Start Recording
-Do your Steps
-Stop Recording
Then, in the Macro Dialog-Window Select your Test-Macro and click the Edit-button, eg
to see how VBA has tremendously "translated" your steps into its own VBA-lango.
As simple as that.
Than Copy&Paste down the Macro, eg and by making the changes for the required
tickersymbols and/or Sheet(s) names and/or Cells' contents would do the job.
WorkAround-2
--------------------
Open a brandnew instance of Excel and on the first available sheet(cell A1) start working
with using the columns for your line(=row) divisors. Eg, a sentence line(=row) like :
ABC MyFormula +ABC!E$5
can be split over 5 seperate columns {headers here are only given for better reading} :
Ticker Formula Tool Symbol Reference
ABC MyFormula '+ ABC '!E$5
{note the ' upper comma character placed upfront in a columns cell will not have the next
character being used for a formula's function tool, eg but what is placed at the right
will only be displayed as a text string}
>From this, click the top of the 1st (Ticker) column's header (selecting the full column down
and full column will get blackened), cut and paste(insert) the column over to the 4th (Symbol)
column AND now to become the new 3td column(eg deleting the old Ticker column) :
Formula Tool Symbol Reference
MyFormula '+ ABC '!E$5
When finished, save as this sheet as a XLS workbook for Type (eg for backup purposes).
Now, when finished, save as this sheet as a TEXT-file(TAB-dilimitted) for Type.
Open Word(or WordPad) and go to the first line to Select the now (blanc) TAB positions in
this text-file. (The TABs are white peaces of line between the columns contents (much as they
are also blanc when looking at the example given above).
After Selecting, (right) click for Edit|Copy or hit "CTRL"+"C".
Then on the WorkMenuBar click Edit|Replace.
In the Find&Replace dialog window place your mouse-pointer in the tiny top window and hit
the keyboard's "CTRL"+"V" keys.
Click "Replace All"-button and save TXT-file.
Now Open the file again, click Edit|Select All and Copy and Paste contents to your own
self designed worksheet (eg to the B-column you mentioned in your mail).
Regards,
Ton Maas
ms-irb@xxxxxxxxxxxxx
Dismiss the ".nospam" bit (including the dot) when replying.
----- Original Message -----
From: Ed Middleton <emiddleton@xxxxxxxx>
To: Metastock list <metastock-list@xxxxxxxxxxxxx>
Sent: woensdag 30 juni 1999 2:13
Subject: Off Topic: Excel function
> Anyone know how to reference a worksheet name in a cell from another cell?
>
> For example:
> I have a list of 10 stock symbols in column "A".
> Each of the 10 stock symbols has a designated worksheet.
> In Column "B" I want to gather the value of the stock as given in the
> designated worksheet. I would like to be able to copy the formula down the
> page once the first one in Column "B" is set.
>
> Column Column
> A B
>
> ABC +ABC!E$5
> DEF +DEF!E$5
> GHI +GHI!E$5
> JKLM .
> NOP .
> . .
> . .
> . .
>
> If it were only 10 rows I could do it manually but I have numerous
> spreadsheets all referencing about 70 sheets. I would guess that I have
> about 3000 lines that I need this formula for.
>
> I would really appreciate any help.
>
> thanks in advance,
>
> Ed
>
>
|