1. There are little delays in Index and Currency pricing. We are working to resolve it.
    Dismiss Notice

New MarketXLS Release Version 8.0.0.6

Discussion in 'Announcements, Updates and New Releases' started by marketxls, Sep 6, 2017.

New MarketXLS Release Version 8.0.0.6

  1. marketxls

    marketxls Administrator
    Staff Member

    Joined:
    Dec 21, 2015
    Messages:
    1,005
    Likes Received:
    10
    Following are the key updates in this release of MarketXLS….

    1) Financial Statements and Historical Fundamental Data

    In this version, we have reworked on the Fundamental analysis section and enabled "download financial statements" options. It works the usual way where you would simply select a cell with a valid symbol and click on menu items as shown below...

    You have both quarterly and yearly options. Apart from the financial statement, you will be able to download all key ratios of a stock at one go. And most importantly, all the fundamental data for a stock like shown below.

    [​IMG]
    We have intentionally not "Number formatted" the values because everybody would have their own preferences.

    Please send us back your feedback and comments on these so we can improve them in coming releases.

    [​IMG]

    [​IMG]

    [​IMG]

    * note this is currently available for US/CAD stocks only but we are working to get better coverage.


    2) New Function Reference

    Many of you asked for a single place where you can quickly refer to MarketXLS functions, so we have created a new menu item in Settings/help as shown below.
    [​IMG]
    With this, you always will have the latest view of MarketXLS functions. We are also working on adding more documentation in this file based on your feedback.

    We are also working to add default IntelliSense on all MarketXLS functions like shown below, so you do not have to refer to any file. Hopefully, we will release these in coming releases.

    [​IMG]

    3) "Run for Market"

    I was to share with you in advance something very exciting that we are working on. We are working on a way to run your boolean Excel formulas against the whole market and return qualifying stocks.

    For example... let's say you want to find out all stocks trading below $1. You will write a function in Excel like =Last("Symbol")<1 , since this is a boolean function that returns a true or false. You will be able to right click on this cell and click on "Run for Market" to return all stocks that return true as well for this formula. Similarly, something like =PERatio("Symbol")>X and so on.

    Imagine the possibilities we will have when we can do this for fundamentals, pricing, key indicators, ratios and everything else. On the top of it, we will be able to save such formulas with a name and use other MarketXLS user's formulas (kind of like creating your own screeners and using other's as well).

    We have already moved quite ahead on this and we are almost there. In case you have any ideas you want us to incorporate please do reply to this email.

    4) We need your feedback to help shape MarketXLS:
    From the time we started, your feedback has shaped MarketXLS development and we want to continue doing that. It would be a great help if you could take out a minute to answer 4-5 questions in this survey.

    We will make sure that your responses turn into usable functionality in MarketXLS which we all can use to advance our returns in the markets.


    5) Other fixes and improvements
    * Improved UI, messages, and feedback
    * Improvements in Barchart module
    * Fixes on Portfolio Module

    Below are the key tasks we are working on for coming releases...
    1) Integration with Metastock
    2) New Price screener to be able to screen stocks on quotes and volatility
    3) Add more price/volatility related screeners just like the RSI one.
    4) Buying & integrating new data on earnings, estimates and Canadian Options
     
  2. Rutger Olsen

    Rutger Olsen New Member

    Joined:
    Jun 29, 2017
    Messages:
    1
    Likes Received:
    0
    Where is the download link? I am unable to find it anywhere on the website.
     
  3. marketxls

    marketxls Administrator
    Staff Member

    Joined:
    Dec 21, 2015
    Messages:
    1,005
    Likes Received:
    10
    Hi Rutger,

    It was sent in an email to you. Let me know if you did not get it? I just sent you a private message just now as well.

    Kind regards
    Ankur
     
  4. Richard Ottaviano

    Richard Ottaviano New Member

    Joined:
    Aug 4, 2017
    Messages:
    1
    Likes Received:
    0
    Hi Ankur,

    When I click on the link in the email it goes to a blank page saying "No URL found for this tracker ID"

    Rick
     
  5. lberry27

    lberry27 New Member

    Joined:
    Oct 10, 2016
    Messages:
    7
    Likes Received:
    0
    I'm also getting: No URL found for this tracker ID

    Lester Berry
     
  6. marketxls

    marketxls Administrator
    Staff Member

    Joined:
    Dec 21, 2015
    Messages:
    1,005
    Likes Received:
    10
    Just sent you the links.
     
  7. marketxls

    marketxls Administrator
    Staff Member

    Joined:
    Dec 21, 2015
    Messages:
    1,005
    Likes Received:
    10

Share This Page