Visokio website     Downloads     Video tutorials     KnowledgeBase  
FX rates - Visokio Forums
FX rates
  •     sherriff April 23, 2011 9:29AM
    I would be interested to know whether a Data Feed block could be established to provide Currency exchange (FX) for easy automated use in Omniscope.

    One useful free source is the EU Central Bank. This data can be used as a suitable reference for many accounting and financial purposes. parsing from XML could be useful.

    http://www.ecb.int/stats/exchange/eurofxref/html/index.en.html
  • 1 Comment
  •     steve April 26, 2011 12:32PM
    Yes, this is indeed possible. The formula function READRES will download the feed data as a text value containing the XML. You can use text manipulation functions such as SEARCH to find the data your want.

    This is very tricky, though. From tonight, 2.6 b612, there are two new functions which can be used instead in combination with READRES:
    REPLACEREGEX - does a regular expression search and replace, allowing back-references
    XPATH - evaluates an XPath expression against an XML document.
    You can use either - in this case, XPATH is easier. Try the attached IOK file in 2.6 b612 or later to see the two new functions in use with this currency data.
    Attachments
    currencies.iok 6K

Welcome!

It looks like you're new here. If you want to get involved, click one of these buttons!

Sign In Apply for Membership

Tagged