Question for Grob/Hershey...

Discussion in 'Trading' started by makosgu, Sep 4, 2005.

Thread Status:
Not open for further replies.
  1. Video formats are kind of odd since in and of themselves they are compression algorithms much like zipping. What may be convenient is to use what's called a file splitter of some sort. There are various media splitter tools. AVI Splitter is one such tool which will break down the file into smaller files, however it is has a maximum input size limit of 10MB or so. In any event, I'm sure there is a bunch of other similar tools that are readily available.

    Regards,
    MAK
     
    #2331     Apr 11, 2006
  2. nkhoi

    nkhoi

    #2332     Apr 11, 2006
  3. Ireland

    Ireland

    Grob,

    www.yousendit.com is similar to filefactory but less advertising and no waiting for downloads. The link though will expire after 7 days. The preferred longer term solution might be to host the files on a private web site and have links to the avi from the relevant ET thread
     
    #2333     Apr 11, 2006
  4. Yes- my bad. Often I think ten times more information than what I write. What I meant by zipping the file is that it is probably the only ET-approved method of posting an avi file - you would get very minimal additional compression. You could rename the file and change the extension, but that may be against the TOS.

    As to posting a large file to ET, I don't see any way to get around the size limitation except by your suggestion and then making a bunch of posts. Which people then have to download and reassemble - and I suspect that the majority of people will not do that.
    Would I? Yes - but as others have suggested, there are more elegant ways to accomplish a distro.
     
    #2334     Apr 11, 2006
  5. Here's the IB fix...

    Didn't get a chance to look at the IB API till a few moments ago....

    OK. So in B19, put in your usual logic to fire up the DDE app. You want to have a formula in cell B19 as opposed to syntax. The formula serves 2 purposes, the first being to fire up the app that connects to your tws, and the second is to tag the symbol with a UNIQUE ID. If you have multiple IB DDE windows open, make sure that the tag id your using for ES has not already been assigned to another id which has been associated to some other symbol...

    For example, in the IB PRV version floating around, it is using "id501" for ES. If you decide to use "id501" for ES, be sure that it is not being used elsewhere to also id YM or something like that. If it is, then use a different symbol (ie. "id502").

    So in cell B19, plug in the FORMULA SYNTAX

    "=yourIBid|tik!id501?req?ES_FUT_200606_GLOBEX_USD"

    This maps id501 to the IB's ESM6 futures data.

    The other problem some of you were facing is due to a minor excel glitch that arises from the adhoc to using IB's timestamps. Currently, your b17 reads

    "now()"

    Change it to the STRING SYNTAX

    "now()-today()"

    OK. Problem 2 fixed...

    Finally, B18 is as it was before (STRING SYNTAX)

    "yourIBid|tik!id501?volume"

    Note very carefully that if you change "id501" in B19 to some other id, the id change needs to also reflect in B18...

    Irl, let me know if this resolves everything...

    Kind Regards,
    MAK
     
    #2335     Apr 12, 2006
  6. Looks like that fixed it for me.

    Thanks Mak!

    - Note to other IB users: when you first start the spreadsheet up, the first bar (far right) and the pace will peg to the total volume for the day. On the next and following bars, the values will be correct.
     
    #2336     Apr 12, 2006
  7. :cool:

    I won't say much but I am bubbling with excitement... Easy sparked another idea as an add-on, which I rapidly developed during the wee hours last night on how to relate all (STR.NEUT.SQU + PRV). It will incorporate the generic abstraction of STR.NEUT.SQU. :cool: We shall see. I am fine tuning as usual. I'm really encouraged by the great bunch we got here. I'm pretty sure Grob will really like this next component...

    How did the PRV solutions work out? I've got both IB and IQFEED running separately and very nicely...

    Icarus, are you still around? Just curious.

    Kind Regards,
    MAK
     
    #2337     Apr 12, 2006
  8. Ireland

    Ireland

    Mak

    you're a good man - yes indeed this works perfectly - many thanks indeed - observation of PRV in action live is a beautiful thing.

    there is a huge learning opportunity here thanks to your efforts

    merci bien encore

    IRL
     
    #2338     Apr 12, 2006
  9. Working beautifully here Mak!

    Many thanks again!
     
    #2339     Apr 12, 2006
  10. A week ago I couldnt even spell exceller, now I are one.:D You guys are great. Working fine here.
     
    #2340     Apr 12, 2006
Thread Status:
Not open for further replies.