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
|
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;
If {
[(Bar.Close(n-4) > Bar.Close(n-3)) AND
(Bar.Close(n-3) > Bar.Close(n-2)) AND
(Bar.Close(n-2) > Bar.Close(n-1)) AND
(Bar.Close(n-1) > Price(n))] Then
Column.Value = “SHORT”
}
ELSEIF{
[(Bar.Close(n-4) < Bar.Close(n-3)) AND
(Bar.Close(n-3) < Bar.Close(n-2)) AND
(Bar.Close(n-2) < Bar.Close(n-1)) AND
(Bar.Close(n-1) < Price(n))] Then
Column.Value = “LONG”
}
ELSE{
Column.Value = “”
}
ENDIF
The code example is not important to me - I'm looking for the script to output text.
Is there a listing of script codes and thier formating criteria? ie the format the system expects for an IF statement a above?
Thanks,
Ethan
|
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.
|