|
|
|||||||||
|
|
Web Services LinksWeb Services LinksAccess remote data and processing via the webWeb services, many of which are free, can be incorporated into any Omniscope file in two ways: 1). Use the Settings > Web Services > Add web service dialog to add existing services to any Omniscope file containing a column of values acceptable as the input parameter. The sample web services links below all require a U.S. stock ticker symbol. Add as many web services as you want, using any number of Omniscope Web Views to display the automatically-generated results taking user-selected data values as inputs. 2). Some web services can be written directly into Omniscope formula fields as shown in section 2 below 1. Web Services Available via Visokio:Note: when preparing your data sets, be aware of the upper/lower case sensitivity for any web services you plan to draw on. Test the format of the input parameter before preparing your data. If necessary, use the Omniscope Table View > View Tools > Tools > Expand; Collapse; Append & Prepend tools to modify your data to match the required format of the web service input parameter. Data Source: Yahoo FinanceThe services below all accept a lowercase US stock ticker as the web service parameter: Table Chart: for each Symbol, returns Last Trade, Trade Time, Change, Volume and Todays Price:
Line Chart: for each Symbol, shows Price over time for the day:
Line Chart: for each Symbol, shows Price over the past year:
2. Using Formulae to import results from the WebIt is also possible to access web services values using formula fields defined in the file itself and re-evaluated whenever the file is opened or data is refreshed. Example: stock price look-up formula that uses Yahoo Finance as the source based on submission of exchange ticker from the [Ticker] column in the data set, then multiplies by number of shares [No. Shares] to obtain real-time [Current Value] of holdings:
Example: real-time foreign exchange conversions, where [Currency] is the currency pair to be converted in a field in the data set, e.g. GBPUSD. Use the URL below inside a formula syntax similar to the one shown in the Formula Editor screenshot above:
http://download.finance.yahoo.com/d/quotes.csv?s="+[Currency]+"=X&f=sl1d1t1c1ohgv&e=.csv
For more information on using web services in formulae, see the Functions Guide
Adding Web Services to your fileOnce you have confirmed that your data set contains one or more fields (columns) with values acceptable to the web services for which you have a URL, adding the service is easy. With your file open in Omniscope, go to Settings > Web Services > Add Web Service Selecting the Add web service option opens the Web Service configuration dialog:
Add your own Web Service configuration to the file by supplying your own values for: HTTP POST URL: {cut and paste the full URL of the server file/page above} Web Service name: select a name to appear on the Omniscope Web Services menu. ID Field: your data field (column) containing values acceptable as input parameters for the web service Record count limit: can be any number of values, set to 100 by default
That's all there is to it! If you include several web services in your file, you can also configure the text of the web service menu button, e.g. 'Partner Services' in the example shown below:
Try the Echo Test ServiceOmniscope includes a test web service that 'echos' whatever field (column) of values you choose to send. Try configuring this web service using the default Visokio URL given, with a name like 'Echo Test', and select any field in your data set. Switch to one of the views in Omniscope, and select less than 100 records, then (on the Main Tool Bar web services menu button) click on the 'Echo Test' web service. If you have configured a Web View to display the web service results, they will appear in that open Web View. If you have not configured a Web View in Omniscope, your default browser will open and display the echo results, which are being returned from a Visokio server.
|
