saving code to excel but losing ";" semicolons.

[mluttph]

I like to save my studies to excel, I have never had a problem until recently. Now when I paste them they are missing the semicolons at the end of the lines. Hope someone has a fix for this.
Thanks

 

[mluttph]

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

 

[halcyonguy]

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

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.

 

[mluttph]

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.

 

[halcyonguy]

Yes and I use an excel spreadsheet to help me gage my strategy.

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.

 

[mluttph]

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.

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.

 

[MerryDay]

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.

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.

 

[mluttph]

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.

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.

 

[MerryDay]

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.

When plotting on a chart, it is best to have both buy and sell in the same study.
For conditional orders, it is better to have them separate.