Recent content by jimmy2shoes

  1. J

    Automated Excel Trading programming

    I have a spreadsheet that contains all the daily data, along with the EMA and SMA! I then have a row that shows when the prices cross over, which give a cell that contains (buy/cell) I would idealistically have a cell that purchases on the buy order, sells on the sell order, but, then turns the...
  2. J

    Automated Excel Trading programming

    It is simulation. The Buy/Sell signals are given through a simple MA cross over system i.e. Buy when 10MA goes above 20MA and so on. I have others for RSI and a few other indicators. But, its easy to change the formula once you can see it. Thanks in advance
  3. J

    Automated Excel Trading programming

    could anyone help please. Once i have created the Buy/Sell Signals. How do i then get a system where.... If the cell contains a buy i purchase 500 shares of (x)? But, if it says Sell i sell 500 shares of (x)
  4. J

    Modern Portfolio Analysis

    Why do so many people spend their lives analysing Large-Mid cap companies perspectives? When truly with enough determination, logistical knowhow and simple fundamental analysis, penny stocks should be, 'The be all and end all'? If one can be provided a stock with a positive PEG/PE with a low...
  5. J

    Excel trading (help needed)

    Could someone please help me with some excel formula? I am trying to create a cell, that uses a reference from another cell that says "BUY". I need the cell to say that once this cell says "BUY", literally/theoretically, Buy one share, at price listed in Cell G21. i would continue and hold this...
  6. J

    Automated Excel Trading programming

    This works perfectly. + actually seems to be quite good at predicting the swings. Are you able to edit for formula so that instead of no trade if for example the previous cell says 'sell' then this continue until a new warning/a strong sell signal occurs? Also in regards to MA's i have used a...
  7. J

    Automated Excel Trading programming

    Its done/updated on a daily basis. I am using a MAC:Office 08 which unfortunately does not have the add-ins, the statistical packages or VBA for updating intra-day. I am sure you would be able to do this on a very fast windows computer with VBA!
  8. J

    Contemporary Economic Issues

    done hopefully you will be able to find it under a new post/same title
  9. J

    Automated Excel Trading programming

    as of yet no, but it does contain the RSI and about 20 other indicators.... ive done this work its just trying to get all the right formulas so that i can have all the signals give me buy/sell signals together. Then once the different indicators i.e. cycle indicators, market strength, momentum...
  10. J

    Contemporary Economic Issues

    I wrote a paper recently regarding CEI and would like some honest feedback. I wrote this in May 2011. Any/all ideas/thoughts are welcome.
  11. J

    Automated Excel Trading programming

    brilliant thank u. so that would mean that i need to have a sell column, which would show a -1 when the indicator goes below 30, and in the buy column a +1 in the buy column when the signals are hit? have a look at my spreadsheet under 'Excel Trading /partially completed automated trading signal...
  12. J

    Excel Trading /partially completed automated trading signal provider

    this is the second time i try this with the attachment hope it helps. I provide an excel spreadsheet of most of the most important trading oscillating indicators. I am in mid-process in developing how i can make it into an automated signal based trading programme. It seems very hard to find...
  13. J

    Contemporary Economic Issues

    so it is i will post this item again under the same title with an uncorrupt version. Will do tonight.
  14. J

    Excel Trading /partially completed automated trading signal provider

    I provide an excel spreadsheet of most of the most important trading oscillating indicators. I am in mid-process in developing how i can make it into an automated signal based trading programme. It seems very hard to find these kind of programmes out there for free. I have spend days making it...
  15. J

    Automated Excel Trading programming

    I am trying to create an automated trading warning system. I am trying to get signals so that for exmaple when the RSI/MA reach a certain point it would give me a buy/sell signal could anyone please help me in giving me a formula? So that when cell-x = below 30 it would say Buy/ when it reaches...
Top