This is a migrated thread and some comments may be shown as answers.

How to import data and format from Ajax content?

1 Answer 54 Views
Grid
This is a migrated thread and some comments may be shown as answers.
Kevin
Top achievements
Rank 1
Kevin asked on 24 Oct 2012, 01:21 AM
I would like to download / import data from following webpage to excel.
http://www.dukascopy.com/tradercontest/?action=liveForecast
Once you go to that page, change instrument to any, so all three parameters are "Any" 

You will see there are quite a few pages with 10 trades on each page and all these trades are are having one of three background colors.

I want to import all these trades from all of the pages in excel on an interval of say 1 or 5 minutes or if the trades are imporeted when the excel is opened, it is acceptable as well.

So I have updated web address to fetch data from page 1,2,3 and likewise which are as follows.

http://www.dukascopy.com/tradercontest/?instrument=USD%2FCHF&side=&state=&trader=&page=1&sort_by=&sort_dir=ASC&action=forecastGrid&ajax=1

http://www.dukascopy.com/tradercontest/?instrument=USD%2FCHF&side=&state=&trader=&page=2&sort_by=&sort_dir=ASC&action=forecastGrid&ajax=1

We have to change the page=1 to page=2 to page=3 and likewise. 

If I use the above updated web addresses, I am not able to grab the back ground color of each trade in a way that the background color appears on first link above.

So the requirement is to import all the trades from all of the web pages with back ground color as a separate column is excel.

Please let me know if anyone have the solution.

Thanks and regards.

1 Answer, 1 is accepted

Sort by
0
Daniel
Telerik team
answered on 26 Oct 2012, 04:57 PM
Hello Kevin,

Thanks for the live URL. Do you use any Telerik control from the AJAX suite in your website?
In theory you could export your data, provided that you have the required data on the server.

Best regards,
Daniel
the Telerik team
If you want to get updates on new releases, tips and tricks and sneak peeks at our product labs directly from the developers working on the RadControls for ASP.NET AJAX, subscribe to their blog feed now.
Tags
Grid
Asked by
Kevin
Top achievements
Rank 1
Answers by
Daniel
Telerik team
Share this question
or