Thanks - at least I know I'm not nuts...about this anyway.

Re Q2 is there a way to export the watchlist results to a spreadsheet? When I copy paste I only get the tickers.

Thanks,

Ethan

Thank You :)

Looking for a column to show percent above or below 50 day moving average. Likewise the 200day moving average. Did not find a prebuilt for this...if it doesn't exist please help with a script.

Thanks,

Ethan

Hello,

I'm using red and green check marks in colums sets to indicate True/False for various conditions.

I also use Red and Green numbers to highlihg - or + change.

I recently changed the column sets background to white so I could screen capture a photo of my results and print them. For some reason when I save the column set or, even save the entire workspace it loose my color selections....most get reset back to black - some of the green ones remain. Please advise.

Second Question - is there a way to export a Workspace grid including the values etc to a word doc or spreadsheet? All I get with copy and paste is a list of the Symbols.

Thanks,

Ethan

I'm trying to work with prior weeks and months - when I use the formula you gave me in a column It says "daily" and no longer lets me adjust the time aggregation period - the little box for time in the  customze columns area has disapeared.

I'd like Prior months performance etc.

How do I add  a % sign after my formula for a watchlist?

just a smiple calculation for % up for the period.

(C -O)/O

Can you confirm that the below is correct for "Last months % move"?

(C1-O1)//O1

Thanks,

Ethan

My goal is to be able to create a custom sort for symbols in my watchlist. instead of alphabetical;

I'd like to assign a number to the symbol then sort by that column something like this;

If Symbol=SPY then SYNBOLnumber =1

else

if Symbol=AAPL then SYNBOLnnumber =2

else

SYBOLnumber = 0

Is there a way to call up the symbol for comparison in TC2000 version 12.2?

Can you suggest some code for this?

Thanks,

Ethan

I'd like to create criteria that produce a text that can be displayed in a column. ie to test for conditions and output a word.

I found an exaple question from 2008 in which you said it could not be done - but lots has changed since then. Here is that example;

I searched and read several posts on this topic but have not deduced an answer to my questions. Hopefully I've titled my post and asked questions in a way that will benefit furutre searchers.

I've set up columns for a particular stock gurus method - the coditions I use for columns is as follows

Using a green check mark if true/red if false

• Current bar above it's open
• Current bar is below it's open
• Current bar is an insidebar
• Prior bar was an inside bar and now current bar has traded above prior bars high.
• Prior bar was an inside bar and now current bar has traded below prior bars high.

 I am a gold user - when setting the columns I can choose refresh rate 30 min 60 min and "manual"

Q1. How do I trigger the manual refresh?

Q2. can I trigger a manual refresh for all columns at once?

Q3 I know as a gold user I can only use daily time frames and above - how quickly in the day will the data be correct - ie if today broke above yesterday's inside bar - how early will my columm check mark indicate that?

I'm considering upgrading to Platinum so I can test bars intraday

Q4 what are the available refresh rates  in platinum?

Q5  How quickly will the data be correct for a new 5 minut bar for example?

Thanks,

Ethan

Thanks mucho....I never know which is more curtious - to thank you which makes you read yet one more post, or to not respond which doesn't tribute how great you are at helping.

anyhow - Thank you.