Page 1 of 1

extract part of a structured text

Posted: 16 May 2013 20:17
by xxx
Hi,

I want to get the latest DAX level using http request:

http://finance.google.com/finance/info? ... EXDB%3aDAX
The response looks like the following:

// [
{
"id": "14199910"
,"t" : "DAX"
,"e" : "INDEXDB"
,"l" : "8,324.84"
,"l_cur" : "€8,324.84"
,"s": "0"
,"ltt":"9:45AM GMT+2"
,"lt" : "May 15, 9:45AM GMT+2"
,"c" : "-14.27"
,"cp" : "-0.17"
,"ccol" : "chr"
}
]

Is there a possibility to extract the index level of 8,324.84?

Thanks.

Re: extract part of a structured text

Posted: 19 May 2013 23:52
by plm
Yes, it's possible...
I attach a flow that does the dirty work but you have to set it to your needs.
You can test the flow by running it from within Automagic or by creating a Toggle Widget that toggle the variable global_dax : the DAX index will be displayed by a screen notification.
Obviously, the flow needs to be improved adding, for example, the error handling in the event of connection not available, etc.
Best.

Re: extract part of a structured text

Posted: 20 May 2013 09:08
by xxx
Works fine. Thanks a lot. :-)

Re: extract part of a structured text

Posted: 20 May 2013 09:45
by plm
Glad that is right for you... :D
Best.