Exporting to Excel?
-
- Posts: 4
- Joined: Wed Mar 28, 2007 11:53 am
- Location: California
Exporting to Excel?
Is it possible to export directly into Excel?
- Terranin
- Site Admin
- Posts: 833
- Joined: Sat Oct 21, 2006 4:39 pm
Re: Exporting to Excel?
ForexBugg wrote:Is it possible to export directly into Excel?
Export what?
Hasta la vista
Mike
Mike
- Terranin
- Site Admin
- Posts: 833
- Joined: Sat Oct 21, 2006 4:39 pm
ForexBugg wrote:I tried to create a text file to export to, but the data did not export. What is the process to export testing results?
You can export account history to text file - on the Account history table click with right mouse button and choose "Expot history to file" then type file name with extension .txt and press ok.
Hasta la vista
Mike
Mike
-
- Posts: 9
- Joined: Mon Dec 11, 2006 7:11 am
- Contact:
You can export data to excel but its a two step process.
First, save data as a text file (Follow Mike's instructions on saving as text) and save it as a .txt file on your desktop. Remember the name
Second, open Excel and then go File>Open an then search for the file you just saved as .txt
Third, you'll get a dialog box called "Text Import Wizard". There will be 3 steps.
a) First step, make sure you choose "Delimited", and hit NEXT
b)Second step, make sure you put a check on "TAB" only, hit NEXT
c)Last step, make sure you choose "GENERAL", hit NEXT
This should convert info into excel usable data. Hope this helps!
Rich
First, save data as a text file (Follow Mike's instructions on saving as text) and save it as a .txt file on your desktop. Remember the name
Second, open Excel and then go File>Open an then search for the file you just saved as .txt
Third, you'll get a dialog box called "Text Import Wizard". There will be 3 steps.
a) First step, make sure you choose "Delimited", and hit NEXT
b)Second step, make sure you put a check on "TAB" only, hit NEXT
c)Last step, make sure you choose "GENERAL", hit NEXT
This should convert info into excel usable data. Hope this helps!
Rich
Rich
-
- Posts: 2
- Joined: Fri Aug 28, 2015 10:48 pm
Re: Exporting to Excel?
You guys have made it very complicated to export trade history results.
I did exactly as you said and excel does not arrange the data in proper columns but it displays it the same as in txt file.
Now I have cut and paste one by one and arrange the data which is very tedious.
Kindly provide an option to export trade history to html file like in MT4....
Pls make it simpler. Pls dont make it complicated.
I did exactly as you said and excel does not arrange the data in proper columns but it displays it the same as in txt file.
Now I have cut and paste one by one and arrange the data which is very tedious.
Kindly provide an option to export trade history to html file like in MT4....
Pls make it simpler. Pls dont make it complicated.
-
- Posts: 1479
- Joined: Mon Apr 01, 2013 3:55 am
Re: Exporting to Excel?
Hello,
What version of Microsoft Excel do you use?
I use Microsoft Office 2013 and when I export trade history into Excel file everything work properly and the file has such columns.
Order # Symbol Type Lot Open time Open price Stop loss Take profit Close time Close price Swap Pips Profit
What version of Microsoft Excel do you use?
I use Microsoft Office 2013 and when I export trade history into Excel file everything work properly and the file has such columns.
Order # Symbol Type Lot Open time Open price Stop loss Take profit Close time Close price Swap Pips Profit
Return to “General Questions about FT”
Who is online
Users browsing this forum: No registered users and 24 guests