- ago
It seems that a SQL server interface is not in the cards for WL7.
Here is another path in lieu of SQL server.
WL6 has a file interface for reading static quote data.
Is there a way WL7 can read quotes from files as follows?
a) One day OHLC static data
b) One minute OHLC static data for non-streaming part
c) Say 5 second quotes based on file changed events for streaming.
I have an app that generates this type of data.
Currently (b) and (c) are written to SQL server but it can easily be written to files.
Thanks!
2
1,320
5 Replies

Reply

Bookmark

Sort
Glitch8
 ( 12.08% )
- ago
#1
Yes, there is a built in ASCII Provider you can use to create a DataSet based on static files like this.
0
- ago
#2
Thanks!
Can WL7 also read streaming say 5 second quote data from files?
Probably using file changed events.
0
Glitch8
 ( 12.08% )
- ago
#3
Believe it or not we didn't think to add that and it has never before come up as a request! It seems like such a specific requirement, but if you have some development chops you could code this up yourself using the Streaming API. You'd basically be building your own homebrew extension. Click the Support link above, then Extension API for more details.

Here's the direct link to the Streaming API doc:

https://www.wealth-lab.com/Support/ExtensionApi/StreamingDataProvider
0
- ago
#4
While this initially seems like a single-user solution, a "Streaming ASCII provider" may become a needed feature for power users.

And maybe even a replacement for SQL data provider since there apparently are ways to do it via script / stored procedure (bcp, sqlcmd):

https://stackoverflow.com/questions/26773962/sql-server-stored-procedure-to-export-select-result-to-csv
https://www.codeproject.com/Questions/546777/HowplusToplusExportplusDataplusToplustheplus-csvpl

Let's hear from the community first and if demand is sufficient, turn this into a #FeatureRequest.
0
- ago
#5
QUOTE:
Let's hear from the community first and if demand is sufficient, turn this into a #FeatureRequest.

Realizing that it would take ages to draw attention to this topic buried among thousands of discussions, I marked it as #FeatureRequest. The wishlist page is visited more frequently.
0

Reply

Bookmark

Sort