List

[Happy Skunk Love]

Howdy,

I sure would love some help. I have a list of 400 stocks on one page of an
excel spreadsheet. I have one cell for each symbol set to say "Buy" when it
meets certain criteria.

In another spread sheet, one that would appear blank at first, I would like
to have it make a moving list of the symbols when they say "Buy". Example:
Symbol IBM meets my criteria, in cell A1 on page 1 it says "Buy".. then on
page 2 the symbol IBM pops up.

Ten minutes later cell CC meets my criteria and says "Buy", I would like the
symbol to appear before IBM on page 2 and push IBM from spot A1 to spot A2....

After half and hour I have 35 symbols that have met my criteria with the
latest one that met my criteria in position A1 with the rest fo the symbols
following that symbol..A2, A3,A4 and so forth...

Would really help if I could figure this out...Thanks!

 

[T. Valko]

This has to be done with programming. You might be better off posting in the
Programming group.

You need an event macro that inserts a timestamp in another cell when the
target cell changes to "buy". Then you can extract all the "buys" in
descending order based on the timestamp.

Biff

 

[T. Valko]

This has to be done with programming.

After some tinkering, this could be done with formulas using circular
references but I would recommend a programming approach.

Biff

 

[Don Guillett]

It would depend on HOW the cell becomes "buy".. If you type it in a simple
worksheet_change event would do where it copies the symbol and inserts
before the 1st available cell on the destination page. More detail perhaps
or a workbook sent directly to me at the address below.A worksheet_calculate
could take ALL buys to the destination page. I once had a series 7 license.

 

[Happy Skunk Love]

Thanks a ton for your response,... I am very very nocive as to my experience
of excel, it took me a week to create what I have created thus far, I don't
know what a worksheet_calculate is ... I am going to send to you the excel
spread sheet that I am working on maybe that could give you a better idea of
what I am doing...

thanks

I am sending it to you under the email of (e-mail address removed)

I am a series 7 trader at a propfirm.

 

[Bernd]

Hello,

If your stock symbols are in A1:A400 of Sheet1, I would put your
formula for the buy condition into G1:G400 of the same sheet, for
example.

So G1:G400 contain either TRUE or FALSE (TRUE meaning: Buy it).

I suggest to apply a conditional format to G1:G400: Format the
background to green if TRUE and to white if FALSE, for example.

In Sheet2 you can array-enter into A1:A400:
=TRANSPOSE(returnnonempty(IF(Sheet1!G1:G400,Sheet1!A1:A400,"")))
[enter with CTRL + SHIFT + ENTER, not only with ENTER]

My UDF returnnonempty you can get from
http://www.sulprobil.com/html/concatenate.html
[Press ALT + F11, enter a module and paste macro text into that
module]

Regards,
Bernd

PS: Do you use a synchronous Bloomberg link?