Welcome Guest, please sign in to participate in a discussion. | Search | Active Topics | |
Registered User Joined: 6/15/2008 Posts: 1,356
|
Something I'm experimenting with is integration with an external database, such as Microsoft Access, through the System.Data namespace.
I've been able to write events into a database so far.
Just wondering if anyone has done this already, or has any interest?
|
|
Platinum Customer
Joined: 7/16/2009 Posts: 411
|
Wait a second. Are you saying you were able to create/add records to a MS Access table directly from SF5 ?
Thanks
|
|
Registered User Joined: 6/15/2008 Posts: 1,356
|
yup
|
|
Registered User Joined: 6/15/2008 Posts: 1,356
|
http://screencast.com/t/MpL3xeG0B
|
|
Platinum Customer
Joined: 7/16/2009 Posts: 411
|
OMG ! This is huge. Are you using SF5.0 or SF5.1 ?
|
|
Registered User Joined: 6/15/2008 Posts: 1,356
|
5.1
you can use all .net namespaces.
I have even used the .io to write events to a local file. however you can't edit afterwards. then you get the .IO not supported error. check my postings on alerts
|
|
Platinum Customer
Joined: 7/16/2009 Posts: 411
|
THANK YOU !!!
You have no idea how much your post helped me.
Did not even try 5.1 because I was afraid it was a dud. Stupid stupid stupid.
I will install it right away.
|
|
Registered User Joined: 6/15/2008 Posts: 1,356
|
:-) good to hear. I have done some fun stuff myself with access. currently running 5 charts, each with different timeframe, all writing into access tables based on conditions.
If you get any bright ideas on how to exploit this, let me know. you're a programmer, I'm just discovering things one thing at a time.
|
|
Platinum Customer
Joined: 7/16/2009 Posts: 411
|
I can definitely tell you what I am planning to do. I use SF during the market hours for quick trades 5 -30mins (max). I have a 0$ loss tolerance policy(no exceptions) => Visibility is critical.
This means that whenever SF triggers a signal (with characteristics such as Buy/Sell, signal type = continuation/reversal, category, timeframe, ...) it calculates the expected target and the approx time to reach it. The signals are displayed in the Log window. => The problem is that often I get many signals, hard to see which one best serves my interests at that moment.
If I can persist the signals in an Access table then I can filter them based on market conditions and my interests at any specific moment (Ex: reversal Sell signals in a TF5 timeframe for solar stocks in previous strong daily uptrend..., or only continuation Buy signals when TF30 BBWidth is expanding and is over a certain value...). Instead of using the DebugLog window I can have my own application that displays the signals and eventually triggers alerts.
I can also merge the signals with other data such as shortsqueeze interest, briefing posts... => everything in one place.
And of course, if I can save them in a table => I have the possibility to review them later.
Don't think this qualifies as a "bright idea" but for me it's 10000 times better than what I have now (yuck - debug log).
Thanks again
|
|
Registered User Joined: 6/15/2008 Posts: 1,356
|
sounds good.
I have also an API from TDA, which I've got working in Access VBA. my ultimate goal is that access can narrow down the signals from SF, choose the highest probability setups, and immediately pops up an order screen with strike and qty pre-filled. all what's left to do is hit the "buy" button. My style of trading is somewhat similar to yours , where the window of opportunity is short, so the more automation, the better.
|
|
Platinum Customer
Joined: 7/16/2009 Posts: 411
|
Could you please confirm, if I install SF5.1 will I be able to continue using 5.0, and switch between them if I want to ?
Thanks
|
|
Registered User Joined: 6/15/2008 Posts: 1,356
|
sorry don't know, I have never used them together on the same PC.
|
|
Worden Trainer
Joined: 10/7/2004 Posts: 65,138
|
Yes, you can have StockFinder 5 and StockFinder 5.1 both installed on the same computer.
-Bruce Personal Criteria Formulas TC2000 Support Articles
|
|
Platinum Customer
Joined: 1/30/2005 Posts: 135
|
I get IO operations are not allowed when I try to use system.IO in SF 5.1
|
|
Registered User Joined: 6/15/2008 Posts: 1,356
|
Yes, if I'm correct worden blocked .IO for obligations they have with their data providers.
but the rest of the namespaces work
|
|
Platinum Customer
Joined: 1/30/2005 Posts: 135
|
I got it to working but it only processes one symbol in watchlist.
'# ROC = chart.ROC
'# EY = chart.EY
Static sym As String
If islastbar And sym <> CurrentSymbol Then
'showmessage(currentsymbol & " " & roc.last)
sym = CurrentSymbol
AddtoDbase(currentSymbol, ROC.value, EY.value)
End If
|
|
Guest-1 |