+ Reply to Thread
Results 1 to 2 of 2

importing CSV datas from web login/psw broker account problem

  1. #1
    Registered User
    Join Date
    03-24-2014
    Location
    Spain
    MS-Off Ver
    Excel 2013
    Posts
    1

    importing CSV datas from web login/psw broker account problem

    Hello folks,

    I am having problems trying to build an Excel which imports automatically my Account Summary CSV datas from my LMAX trading account.

    While attempting to make a New Web Query from the login access page https://testapi.lmaxtrader.com/portal/ , some script errors occours and I can't access from there into my Lmax Client Portal. The errors are the following:


    Line: 22
    Char: 13
    Error: 'JSON' is undefined
    Code: 0
    URL: https://testapi.lmaxtrader.com/lmaxt...publicLogin.js

    It seems that this broker is not supporting the in-build Internet Explorer of Excel, but I don't know how to change the browser of the New Web Query.

    The broker client support is not helping me, saying this url is the only way to access to the account.

    I've tryied the different types of connection from the Excel's menu, but they did not worked.

    My goal is to can load the Account Summary CSV data, archived in the "client portal", after logging in....

    My Demo login is: virusseder

    Password: dalavatre999

    Thank you very much!

  2. #2
    Valued Forum Contributor
    Join Date
    08-22-2011
    Location
    Auckland
    MS-Off Ver
    Excel 2019
    Posts
    716

    Re: importing CSV datas from web login/psw broker account problem

    Hi Pinos
    After Googling to find out who they are & whether they're legit or not, I accessed your demo account easy enough with IE & Firefox, downloaded your empty account summary ok.
    No idea if excel can open a csv from a webpage, but I don't think so.

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. Excel 2010 Tutorial 12 Case Problem 4 The Brass Broker Part 5
    By mar2241479 in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 04-21-2013, 04:32 PM
  2. compare oracle table datas and excel datas
    By james94539 in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 03-01-2013, 03:48 PM
  3. Authenticate Excel for Web Queries Requiring Login Account
    By cnodnarb in forum Tips and Tutorials
    Replies: 0
    Last Post: 11-18-2012, 09:53 PM
  4. macro/vba to login an online XX account
    By yellowpower in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 11-12-2010, 06:40 AM
  5. re : Finding the datas and deleting datas which are not found.
    By ddiicc in forum Excel Programming / VBA / Macros
    Replies: 7
    Last Post: 08-30-2005, 09:05 AM

Tags for this Thread

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1