Search results

  1. Sam Mcgee

    Medved QuoteTracker quote source ?

    Your original question was who has free data. Scottrade has free real time data for stocks and options that works with Quotetracker.
  2. Sam Mcgee

    charts in excel

    Excel has a charting function built in, here's some information on how to use it: http://pubs.logicalexpressions.com/Pub0009/LPMArticle.asp?ID=209 That should do what you need. If you're wanting to chart prices, technical indicators etc and use them in conjunction with Excel, Sierrachart...
  3. Sam Mcgee

    The dangers of Euro to the Dollar

    Actually the current oil sands production is in excess of 1 million barrels a day. However, I was writing about the total reserves, not the current "reserve production capacity". If the US is using 20 million barrels a day, and there is about 1 trillion barrels in the Canadian tar sands...
  4. Sam Mcgee

    The dangers of Euro to the Dollar

    If I were living in the US I would fear Dick Cheney more than Osama Bin Laden. He's done more harm to the country than the terrorists could ever dream of doing. From what I can see he is only using Bush, Rumsfeld and others to achieve his goals. With all due respect to the innocent lives...
  5. Sam Mcgee

    Owing money loses stigma for rich, poor alike in U.S.

    The trouble in America is that debt is subsidized and encouraged with tax deductions. A simple solution to decrease consumer and repay government debt would be to put an end to this subsidy. Who was the one who started this system of tax deductible mortgages? As far as I can see, it'll be a...
  6. Sam Mcgee

    vitamins mineral and foods good for trading

    I don't think it's good for our immune system to live in a sterile environment. I believe that for the immune system, "what doesn't kill me, makes me stronger". Look at the North American Natives, they were never exposed to the common cold until the white men came over. Then a lot of them...
  7. Sam Mcgee

    vitamins mineral and foods good for trading

    Inadequate vitamins and minerals can affect your sanity: http://www.hon.ch/News/HSN/509174.html http://www.luminet.net/~wenonah/new/mental-h.htm There are thoughts that with intensive farming we have deprived our soils of important minerals and so we can't get them from eating normal...
  8. Sam Mcgee

    Cheapest real-time charts?

    You can use Scottrade data connected to Medved Quotetracker and both of them are free.
  9. Sam Mcgee

    Nasdaq100 E-mini volume dropped in 2005

    Yes, I was sloppy in how I placed the zeros, they should be: Value, Increment, Trade Inc/Current Value ES 1292 0.25 0.000193 ER2 711 0.1 0.000141 NQ 1760 0.5 0.000284 YM 10995 1 0.000091 You have to also consider the multiplier for...
  10. Sam Mcgee

    Nasdaq100 E-mini volume dropped in 2005

    Nasdaq trades in half point increments and the Russel trades in one tenth point increments. The average spread in percentage terms for Nasdaq is 0.0284% compared to 0.0141% for Russel futures. For SP futures trading in quarter point increments the spread is 0.192% right now. Then again for...
  11. Sam Mcgee

    Change the tick increment in ES from 0.25 to 0.1

    Here's an article talking about bid ask spreads: http://faculty.haas.berkeley.edu/odean/papers/Bloomberg/BloombergArticle.htm Basically the bid ask spread for retail traders is an expense in addition to the commission. Why would anyone want to increase that expense?
  12. Sam Mcgee

    Where to trade shares with no commissions ? Like Forex

    The commission is only a small part of each trading transaction. The larger and less obvious cost is your bid ask spread.
  13. Sam Mcgee

    Change the tick increment in ES from 0.25 to 0.1

    You're saying that low volatility is caused by small tick size. Why do I see the opposite happening? Take a look at after hours ES trading. The spread opens up to around 0.5 but there certainly isn't much volatility. I think what you're seeing is that the markets have changed a lot since the...
  14. Sam Mcgee

    Change the tick increment in ES from 0.25 to 0.1

    I have to admit that I really don't know much about the 0.25 spread and I doubt that many traders do. I'm sure if someone is profiting from it, they don't want me to know. If the CME, some market maker or someone else is buying my ES contract from me and then selling it right away for a 0.25...
  15. Sam Mcgee

    Change the tick increment in ES from 0.25 to 0.1

    From what I see, the tick size is basically the difference between the wholesale and retail price. We have to buy at retail and sell at wholesale. The spread is not there for the benefit of the small trader. Sometimes it appears that you can buy on the bid or wholesale price but what I see...
  16. Sam Mcgee

    Excel Question for Finding Low Value

    I figured out something here, see attached. Thanks for the response prajsanders.
  17. Sam Mcgee

    Excel Question for Finding Low Value

    I've attached a picture of a spreadsheet to clarify what I'm trying to do. If I could find the row position of the highest value in the last six rows, all I have to do is find the lowest low in that range. In other words, if I can find that the high point was 3 bars ago, all I have to do is find...
  18. Sam Mcgee

    Excel Question for Finding Low Value

    With Excel, in a series of rising pricebars, I'm trying to find the value of the lowest low in a pullback. I have to find this low value separate from price bars that preceded the pullback. The maximum number of bars I look back is 6, but in those 6 bars there may be lower lows before the...
  19. Sam Mcgee

    Can I lose everything?

    What would happen if there was a major terrorist attack and you were long 5 contracts of ES futures. The stock market could close and then reopen later 20 or 30% down and go right through any stops you might have placed. If you had a trading account of $25,000 that would get wiped out and you...
  20. Sam Mcgee

    Help, simple excel...

    Here's an example of visual basic that I recently used to copy a value at the same time each day: Sub Timecheck() Macro1 NextTick = Now + TimeValue("00:00:01") Application.OnTime NextTick, "Timecheck" End Sub Sub Macro1() 'the specified time to check the cell is in A1 If...
Back
Top