How do I build a MisoData app that use URL-based file (time matching variables)?

For a MisoData app that use URL-based files (a.k.a. 'cloud' version), you usually have to specify a public url. 

For example, 
Yahoo Finance provides a URL-based API for requesting stock data, where you can dynamically build a URL with parameters to specify the stock, the date ranges, and the data you're interested in pulling down.

i.e. the URL below:
http://ichart.finance.yahoo.com/table.csv?s=YHOO&d=0&e=28&f=2010&g=d&a=3&b=12&c=2009&ignore=.csv

will return a CSV file for Yahoo (its ticker symbol is YHOO). The URL parameters stand for the following:

sTicker symbol (YHOO in the example)
aThe "from month" - 1
bThe "from day" (two digits)
cThe "from year"
dThe "to month" - 1
eThe "to day" (two digits)
fThe "to year"
gd for day, m for month, y for yearly

With Netvibes, you can use magic parameters (or time matching variables) to format the date using the Date Formatting Codes listed below so that the date appears in the manner you wish


For example, if today is the 5th of May in 2013:
http://ichart.yahoo.com/table.csv?s=AAPL&a={{(-1 month).month0}}&b={{(-1 month).day1}}&c={{(-1 month).year}}&d={{now.month0}}&e={{now.day1}}&f={{now.year}}&g=d&ignore=.csv

The result will be:
http://ichart.yahoo.com/table.csv?s=AAPL&a=3&b=5&c=2013&d=4&e=5&f=2013&g=d&ignore=.csv

As of "format" you can use these:
dayDay of the month, 2 digits with leading zeros, 01 to 31
day0Day of the month before without leading zeros
day1Day of the month without leading zeros, 1 to 31
day2Same as day
monthNumeric representation of a month, with leading zeros, 01 through 12
month0Numeric representation of a month before, without leading zeros
month1Numeric representation of a month, without leading zeros, 1 through 12
month2Same as month
yearA full numeric representation of a year, 4 digits, examples: 1999 or 2003
year2A two digit representation of a year, examples: 99 or 03
year4Same as year
dateSame as year4-month2-day2
timeFormatted time like 16:01:07
epochSeconds since the Unix Epoch (January 1 1970 00:00:00 GMT), aka a simple timestamp
tzoTimezone offset
tzaTimezone abbreviation

Feedback and Knowledge Base