Welcome Guest, please sign in to participate in a discussion. | Search | Active Topics | |
Registered User Joined: 2/10/2009 Posts: 5
|
I have a set of Support & Resistance Alerts in an Excel Spreadsheet that I would like to import into StockFinder. Does StockFinder have a method for importing Alerts from either Excel Spreadsheet or other type of file, such as .csv?"
|
|
Worden Trainer
Joined: 10/7/2004 Posts: 65,138
|
StockFInder does not have a built in method for doing so. That said, it might be possible to combine a variety of RealCode techniques to create something on your own.
The RealCode Programmers Reference has a section on Simulating an Alert with RealCode Rules which covers one method of creating audible alerts in StockFinder.
The following variable Returns the symbol for the currently calculating RealCode:
Me.CurrentSymbol
This means you can create a Rule that only returns True for a specific symbol or symbols (you can get multiples by checking for each symbol indiidually within the same RealCode). An example that would return True when the current Close is higher than $165, but which would only return True for AAPL would be:
If CurrentSymbol = "AAPL" AndAlso _
Price.Last > 165 Then Pass
Another possibility would be to use the techniques outlined in Market Data Reader Overview or RealCode File Reader Overview to create Plots for Support and Resistance and then create Rules for Price being above or below those Plots.
-Bruce Personal Criteria Formulas TC2000 Support Articles
|
|
Registered User Joined: 6/15/2006 Posts: 3
|
Hi,I like the solution that uses import the data first with market data reader... but in that case you have to build many files (one for each symbol)would it be possible to use 1 single file with that kind of data:Symbol;Date;Alert priceor justSymbol;Alert priceand how would this be possible ?I've thought about importing those alert as a "fundamental data" as it can be a constant for each symbol...Thanks !Daniel
|
|
Guest-1 |