Column Calculations

[Enginer]

I'd like a portfolio column that gives (HIGH - LOW) * (OPEN)     which I can use as a rough measure of  value  change per period.  Compared with other equities, it would indicate hint where the most bang for the buck might be found.

Could do this myself if I knew how to export portfolio contents as .CVS to Excel.  Or if a  "Custom Column Calculation" feature existed

[Jerry Medved]

we have a number of computed columns but not quite sure what (HIGH - LOW) * (OPEN) would give you? that looks a bit like an arbitrary value.  Wouldn't range % be a better measure?

[Enginer]

Ah,  I found it!   Another post said Use <shft><ctrl>  to select a transfer.  I found just sweeping the rows wanted turns them yellow--and deposits them nicely in Excel with <Ctrl> V.

 Range % might do it. Have to experiment/think.

Thanks!

[Enginer]

OK.  Help File <search> bombs out on Range % and Range.  Where is it  ::

[Jerry Medved]

they are just columns. right click on any column header and select COLUMN CHOOSER. Then drag the Day Range or Day Range % column to the portfolio

 

will look at adding all the columns to the help

[Enginer]

In excel it takes   =1000*(K5-L5)/F5   to get what I wanted.

[Jerry Medved]

that means nothing without knowing what K5, L5 and F5 represent