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 |

integration with external databases Rate this Topic:
Previous Topic · Next Topic Watch this topic · Print this topic ·
pthegreat
Posted : Tuesday, November 5, 2013 2:07:10 PM

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?

Flash99
Posted : Saturday, January 18, 2014 11:38:30 PM
Platinum Customer 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

pthegreat
Posted : Saturday, January 18, 2014 11:42:19 PM

Registered User
Joined: 6/15/2008
Posts: 1,356

yup

pthegreat
Posted : Saturday, January 18, 2014 11:45:25 PM

Registered User
Joined: 6/15/2008
Posts: 1,356

http://screencast.com/t/MpL3xeG0B

Flash99
Posted : Sunday, January 19, 2014 12:02:52 AM
Platinum Customer Platinum Customer

Joined: 7/16/2009
Posts: 411

OMG ! This is huge. Are you using SF5.0 or SF5.1 ?

 

pthegreat
Posted : Sunday, January 19, 2014 12:07:14 AM

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

Flash99
Posted : Sunday, January 19, 2014 12:15:01 AM
Platinum Customer 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.

 

pthegreat
Posted : Sunday, January 19, 2014 12:22:27 AM

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.

Flash99
Posted : Sunday, January 19, 2014 1:19:53 AM
Platinum Customer 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

pthegreat
Posted : Sunday, January 19, 2014 2:04:11 AM

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.

 

Flash99
Posted : Sunday, January 19, 2014 10:47:37 AM
Platinum Customer 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

 

pthegreat
Posted : Sunday, January 19, 2014 11:41:53 AM

Registered User
Joined: 6/15/2008
Posts: 1,356

sorry don't know, I have never used them together on the same PC. 

Bruce_L
Posted : Tuesday, January 21, 2014 11:47:21 AM


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
maljester
Posted : Friday, January 24, 2014 9:00:28 AM
Platinum Customer 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

pthegreat
Posted : Friday, January 24, 2014 12:36:33 PM

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

maljester
Posted : Sunday, January 26, 2014 3:50:51 PM
Platinum Customer 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
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.