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 |

Importing Alerts Rate this Topic:
Previous Topic · Next Topic Watch this topic · Print this topic ·
vector3257
Posted : Saturday, August 8, 2009 10:11:53 AM
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?"

Bruce_L
Posted : Monday, August 10, 2009 12:51:13 PM


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
xorq
Posted : Sunday, December 27, 2009 5:14:30 AM
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
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.