Download software Tutorial videos
Subscription & data-feed pricing Class schedule


New account application Trading resources
Margin rates Stock & option commissions

Attention: Discussion forums are read-only for extended maintenance until further notice.
Welcome Guest, please sign in to participate in a discussion. Search | Active Topics |

Exporting data and other questions Rate this Topic:
Previous Topic · Next Topic Watch this topic · Print this topic ·
sasworldwide
Posted : Tuesday, October 20, 2009 9:40:40 PM
Registered User
Joined: 7/30/2008
Posts: 30
can I export the data to an Excel file from three different time frames in one layout in such a way that it will give me "1" or "-1" depending which rule is true?

thank you

another question is as follows. let us say I have got three different time frames in one layout and I need assign "-1" if some  rules which are true and "1" if other rules are true. can I have an indicator which makes a sum of "1" and "-1" and plots the result?

thank you

how can I count the bars when a rule is true?

thank you
Bruce_L
Posted : Wednesday, October 21, 2009 6:30:29 PM


Worden Trainer

Joined: 10/7/2004
Posts: 65,138
QUOTE (sasworldwide)
can I export the data to an Excel file from three different time frames in one layout in such a way that it will give me "1" or "-1" depending which rule is true?

If you Export the Rules directly, the results will be True or False instead of 1 or -1. You could create RealCode Indicators based on the Rules that would return 1 or -1 instead however.

'# SC = condition.ScanCondition
If SC.Value = True Then
    Plot = 1
Else If SC.Value = False Then
    Plot = -1
Else
    Plot = Single.NaN
End If

An Export is for a Chart, not a Layout, so if you want all of the Rules with different Time Frames to Export in a single file, you would need to have multiple Rules with different Time Frames in the same Chart.The following topics have examples of Block Diagram based Indicators with adjustable Time Frames:

rules based on different time frames
Seeking Price Rule Based Upon Price Bars With 2 Different Time Frames
Multiple Time Frame

I've also attached a Chart with Drag and Drop Rules based on Price History with Time Frame Indicators that does in fact Export all of the results to a single file. You should be able to Open the attached Chart directly into a running copy of StockFinder.

QUOTE (sasworldwide)
another question is as follows. let us say I have got three different time frames in one layout and I need assign "-1" if some  rules which are true and "1" if other rules are true. can I have an indicator which makes a sum of "1" and "-1" and plots the result?

You would again want to have all of the Time Frames in the same Chart. Once this is done, you could Drag and Drop the Rules into a RealCode Indicator and output the Sum at each Bar:

'# Thirty = condition.ScanCondition
'# Daily = condition.ScanCondition.2
'# Hourly = condition.ScanCondition.3
Dim Sum As Integer = 0
If Thirty.Value = True Then Sum += 1
If Thirty.Value = False Then Sum -= 1
If Daily.Value = True Then Sum += 1
If Daily.Value = False Then Sum -= 1
If Hourly.Value = True Then Sum += 1
If Hourly.Value = False Then Sum -= 1
Plot = Sum

QUOTE (sasworldwide)
how can I count the bars when a rule is true?

What are you counting? How many times it is True in a row? How many times it is True during the history of the data being calculated? How many times it is True over a specific period of time?

Attachments:
sasworldwide42552.sfChart - 86 KB, downloaded 566 time(s).



-Bruce
Personal Criteria Formulas
TC2000 Support Articles
jas0501
Posted : Wednesday, October 21, 2009 8:14:49 PM
Registered User
Joined: 12/31/2005
Posts: 2,499

Another approach, assumming all thee indicators are on the same chart would be to only export when any of then are true and export all 3 values plus the sum.

# Thirty = condition.ScanCondition
'# Daily = condition.ScanCondition.2
'# Hourly = condition.ScanCondition.3
Dim Sum As Integer = 0

...
... compute sum here
...
'
' reduce the exports to only export when the sum is equal whatever
'
if sum = whatever then
    Plot = Sum
   label = Thirty.value & "," & Daily.Value & "," & Hourly.Value
else
   plot. = single.NAN
endif


This will export:

                    symbol,date,time,plot,30 value, daily value, hourly value

only when whatever is satisfied.

Users browsing this topic
Guest-1

Forum Jump
You cannot post new topics in this forum.
You cannot reply to topics in this forum.
You cannot delete your posts in this forum.
You cannot edit your posts in this forum.
You cannot create polls in this forum.
You cannot vote in polls in this forum.