mark8320 Posted October 16, 2017 Report Share Posted October 16, 2017 Hi, this is probably a problem with my Excel 2010, but just in case it is MedvedTrader, can I ask if anyone else has been having problems importing quote data via the .csv file. Mine had been working correctly until today, but now I am getting a quote, such as AMZN 1,003 being imported as 1 and 3 in seperate columns. thanks in advance, Mark Quote Link to comment Share on other sites More sharing options...
Jerry Medved Posted October 16, 2017 Report Share Posted October 16, 2017 how are you exporting it exactly? if you COPY the stuff from the portfolio, it is tab separated, so should be able to just paste into Excel Quote Link to comment Share on other sites More sharing options...
mark8320 Posted October 16, 2017 Author Report Share Posted October 16, 2017 Hi Jerry, using http://127.0.0.1:16239/req?getLastQuote(*, I am getting :- AAPL,10/16/2017,10:59:51,159.33,159.33,159.34,2.34,-,10937517,159.66,157.65,800,400,100,0,0,157.9,104.08,164.94 AMZN,10/16/2017,10:59:51,1,002.84,1,002.69,1,003,-0.10,-,1001568,1,009.57,1,001.04,100,100,100,0,0,1,008.44,710.1,1,083.31 which seperate out to (using comma delimiter) :- 16/10/2017 10:59:51 159.33 159.33 159.34 2.34 - 10937517 159.66 157.65 800 400 100 0 0 157.9 104.08 164.94 16/10/2017 10:59:51 1 2.84 1 2.69 1 3 -0.1 - 1E+06 1 9.57 1 1.04 100 100 100 Quote Link to comment Share on other sites More sharing options...
Jerry Medved Posted October 16, 2017 Report Share Posted October 16, 2017 ok I see. fixing Quote Link to comment Share on other sites More sharing options...
mark8320 Posted October 16, 2017 Author Report Share Posted October 16, 2017 Thanks, posting this in the middle of a hurricane, may loose power at any time in case I do not reply, Mark Quote Link to comment Share on other sites More sharing options...
Jerry Medved Posted October 16, 2017 Report Share Posted October 16, 2017 fixed. download the main production version on our website again and just install. that will fix: https://medvedtrader.com/download Quote Link to comment Share on other sites More sharing options...
mark8320 Posted October 16, 2017 Author Report Share Posted October 16, 2017 Thanks Jerry, that worked !! Mark Quote Link to comment Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.