Rank: Member
Groups: Registered, Registered Users
Joined: 11/15/2008(UTC)
Posts: 17
|
Hey Guys,
I'm reasonably new to MS but am starting to get a pretty good hold on the basics of the MS language (it's all relative, I know) and it's limitations.
I'm interested in coding up the following. Hopefully there's a straightforward way to do it, but I'm suspecting not and that an external function call will be required. Basically I'm looking for the gurus' thoughts on whether or not the below is actually possible and whether it's realistically feasible.
Anyway, the aim is as follows. I have a number of custom indexes. I want to run an explorer using Tradesim ExtFml. I want the explorer to only provide buy signals when the related index is positive (or in a certain state). However, I want to be able to test ALL stocks on the exchange in one go (to allow TradeSim to perform an accurate system test) - hence when deciding to buy/sell the function must first get the stock name, then reference it against a database which will return the specific index which applies to it.This index must then be assessed for it's value. In other words, I can't simply create an index, put all of those
securities in a folder and test them - I need MS to work out whether
the stocks' SPECIFIC INDEX is in a certain state via the database and
ONLY using code and external formulas - no individual testing of index
components.
The database could be xls, or access or any other suitable app. I don't see the problem being in the creation of the database, but more in the calling of the external function with the specific stocks code.
Basically I want to know this: Can an MS function call an external database using the stock code and return a value from that database? If that's accomplishable then the rest would be as well (I hope).
Any ideas, thoughts etc? I'm quite happy for you guys to point me in the right direction and then do the study/work myself (it's the best way to learn anyway) but any kind of help / advice would be appreciated.
By the way, kudos for the site and your collective input. Great learning resource for people new to the software.
Cheers,
Alan.
|
|
|
|
|
|
Rank: Advanced Member
Groups: Registered, Registered Users
Joined: 11/7/2005(UTC)
Posts: 602
|
Track down Wabbit, I am sure he will tell you what you are up against.
|
|
|
|
|
|
Rank: Member
Groups: Registered, Registered Users
Joined: 11/15/2008(UTC)
Posts: 17
|
|
|
|
|
|
|
Rank: Advanced Member
Groups: Registered, Registered Users, Subscribers, Unverified Users
Joined: 10/28/2004(UTC)
Posts: 3,111
Location: Perth, Western Australia
Was thanked: 16 time(s) in 16 post(s)
|
The short answer is, yes this can be done. Exactly how this achieved will require the use of external functions (unless you want to export the entire data libraries into something like Excel then work from there - - yuk!) The precise nature of the external functionality and the database/flatfile interfacing will be dependent entirely on exact nature of the task and will require a lot more discussion than the (good effort) information provided above.
Hope this helps, or at least provides some inspiration!
wabbit [:D]
|
|
|
|
|
|
| Users browsing this topic |
|
Guest (Hidden)
|
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.
