Join useThinkScript to post your question to a community of 21,000+ developers and traders.
I found that this macro probably caused this problem. It's in a backtesting spreadsheet.
Sub CvsFix()
'
' Enhance Macro
'
' Keyboard Shortcut: Ctrl+f
'
Columns("A:A").Select
Selection.TextToColumns Destination:=Range("A1"), DataType:=xlDelimited, _
TextQualifier:=xlDoubleQuote, ConsecutiveDelimiter:=False, Tab:=False, _
Semicolon:=True, Comma:=False, Space:=False, Other:=False, OtherChar _
:=")", FieldInfo:=Array(1, 1), TrailingMinusNumbers:=True
End Sub
Yes and I use an excel spreadsheet to help me gage my strategy.why save studies in excel? do you manipulate the code lines with formulas or macros?
i save my code in text files. no extra formatting to worry about.
Yes and I use an excel spreadsheet to help me gage my strategy.
Conditional orders have length restrictions and do not allow multiple time frames. Strategies are not as restrictive. To make up for that I use excel to make my conditional orders. I mainly use it to concatenate the text string together.changing the actual code lines? not data?
i'm curious to learn more about what you are doing.
i have thought of using vba to interpret code lines and then generate something... maybe this winter i will get to it.
To work around the length restrictions in conditional orders: create the definitions for your conditional order within a study and then reference that study in your OCO.Conditional orders have length restrictions and do not allow multiple time frames. Strategies are not as restrictive. To make up for that I use excel to make my conditional orders. I mainly use it to concatenate the text string together.
That sounds next level, not sure how to do it, but I think I would like to. My strategy has the definitions for my buy and sell orders, do I need to seperate the buy and sell into 2 different files?To work around the length restrictions in conditional orders: create the definitions for your conditional order within a study and then reference that study in your OCO.
There is no workaround for using multiple timeframes in a conditional order.
When plotting on a chart, it is best to have both buy and sell in the same study.That sounds next level, not sure how to do it, but I think I would like to. My strategy has the definitions for my buy and sell orders, do I need to seperate the buy and sell into 2 different files?
I use 5min bars, but I like to compare to yesterdays levels in my study. Since I use yesterday's data I can insert the value into my conditional order and it will not change during the day. For example I may not want to sell if the price is above yesterdays mid point.
Thread starter | Similar threads | Forum | Replies | Date |
---|---|---|---|---|
O | OK is greyed out, when saving a script | Questions | 2 | |
O | saving order as template? | Questions | 3 | |
D | Saving custom scripts and settings | Questions | 5 | |
D | Saving Charts, Layout, Custom Studies, Study Sets | Questions | 2 | |
V | Code error Folding: Integer 'from' is expected. NaN - seek help to fix | Questions | 2 |
Start a new thread and receive assistance from our community.
useThinkScript is the #1 community of stock market investors using indicators and other tools to power their trading strategies. Traders of all skill levels use our forums to learn about scripting and indicators, help each other, and discover new ways to gain an edge in the markets.
We get it. Our forum can be intimidating, if not overwhelming. With thousands of topics, tens of thousands of posts, our community has created an incredibly deep knowledge base for stock traders. No one can ever exhaust every resource provided on our site.
If you are new, or just looking for guidance, here are some helpful links to get you started.