Rank: Advanced Member
Groups: Registered, Registered Users, Subscribers
Joined: 8/16/2005(UTC)
Posts: 182
|
I am using MS 9 Pro eSignal, and I have developed a macro (I think it shouldbe a macro!?) to just key-in the stock number in A1 and display the following:
Last; Change; Bid; Ask; VidSize; AskSize; TotalVol; OpenInterest in cell
B1; C1;D1;E1;F1;G1;H1;I1 respectively
Private Sub Worksheet_Change(ByVal Target As Range)
If Target.Address = "$A$1" And [A1] <> "" Then
[B1] = "=eqddesrv|" & [A1] & "!last"
[C1] = "=eqddesrv|" & [A1] & "!Change"
[D1] = "=eqddesrv|" & [A1] & "!bid"
[E1] = "=eqddesrv|" & [A1] & "!ask"
[F1] = "=eqddesrv|" & [A1] & "!bidsize"
[G1] = "=eqddesrv|" & [A1] & "!asksize"
[H1] = "=eqddesrv|" & [A1] & "!Totalvol"
[I1] = "=eqddesrv|" & [A1] & "!OpenInt"
End If
End Sub
If I want to set a template in which I key-in any cell with the stock number in column A of a spreadsheet, it then returns the last price in the corresponding cells in column B... to I.
How can I do it?
Sa
|
|
|
|
|
|
Rank: Advanced Member
Groups: Registered, Registered Users, Subscribers, Unverified Users
Joined: 10/28/2004(UTC)
Posts: 3,111
Location: Perth, Western Australia
Was thanked: 16 time(s) in 16 post(s)
|
You need to use relative (or offset) referenceing in Excel. The Excel help files have heaps on referencing methods.
wabbit [:D]
|
|
|
|
|
|
Rank: Advanced Member
Groups: Registered, Registered Users, Subscribers
Joined: 8/16/2005(UTC)
Posts: 182
|
wabbit wrote:You need to use relative (or offset) referenceing in Excel. The Excel help files have heaps on referencing methods.
wabbit [:D]
Having search the referencing in excel, but still can't figure out how to do it.......
|
|
|
|
|
|
Rank: Advanced Member
Groups: Registered, Registered Users, Subscribers, Unverified Users
Joined: 10/28/2004(UTC)
Posts: 3,111
Location: Perth, Western Australia
Was thanked: 16 time(s) in 16 post(s)
|
sa,
Send me your spreadsheet and I will show you an alternative way...
wabbit [:D]
|
|
|
|
|
|
| Users browsing this topic |
|
Guest (Hidden)
|
Forum Jump
You cannot post new topics in this forum.
You cannot reply to topics in this forum.
You cannot delete your posts in this forum.
You cannot edit your posts in this forum.
You cannot create polls in this forum.
You cannot vote in polls in this forum.
