Search results

yeah, dunno why. try http://www.419eater.com/index.htm and go to Letters Archive.

Check out http://419eater.com/html/letters.htm. Read the letters by Shiver Metimbers. he is so good, he gets the scammers to send him money!

Kamburov, it sounds like you are not terminating the loop. PM me and send me your excel file and i will fix it for you.

some errors in my last post that I just noticed: The formula for cell A3 is missing a ) The formula for B1 should be: if(reset=0,0,(if A3=1,A1,B1)) - it should refer to itself.

Kamburov: yeah you can do that. I do exactly what you are describing in keeping track of VWAP in excel. This means I have cells (Price and size) that constantly update in real-time through a dde link and keep a cumulative total. As an example, let's say you want to keep a running total of...

KTM, yes, it may be that simple. The reason I came up with the convoluted solution was because anyone who has used excel for 5 minutes understands relative versus absolute addressing so I assumed that Gordon wanted to have the result appear without having to repeatedly copy down the formula...

OK, i thought first this was just a simple AVERAGE(B1:B100) and copy down. This is so basic though that this cannot be what you are asking. I assume that the cell that has the result is in another spreadsheet or is a static cell so I came up with this...

Nana: when you talk of fair value and value area, you are confusing two separate concepts. Fair value, as found each day at programtrading.com, provides the "fair value" of the S&P futures contract compared to the cash index. Today (monday), it lists fair value as -1.14 with program buying...

OK, this is my first post after 2 years of lurking. I have attached an excel summary of 5 stocks 15 min data including volume by time of day. The columns are as follows: Time in 15 min segments 15 min volume 15 min volume as % of 20 day average volume HOD: when that 15 min period...