MP on excel

[ryker]

	Quote:	Ricardo Salas
	Hi: First of all I want to thank Ryker and Boba for their contributions to create a MP program in excel. I'd like that you could add a window on the left that shows the data for the day you chose. The windows must have the following data: Date, The total number of TPOs, For exemple: (169) The TPOs above the POC, the TPOs at the POC, the TPOs below the POC, For exemple: (91/10/68) Put also the prices above in % of the total number of TPOs. The RANGE(in points)=high price-low price. (15.25) In the profile please on the left add a color column, showing the Initial Balance for the first hour of trading and on the right add another column that shows the Value Area. I know that I asked to be implemented too many things, but I think they could help too. Cheers Ricardo

Hi Ricardo,
Thanks for your suggestions. Will put some in my TODO list, but don't know at all when this is gonna be implemented yet...

For the IB and the VA you have some colours on the chart that show them.

[TinGull]

	Quote:	ryker
	Possible, although, I think it's more coming from the data you're using rather than from Excel 2007. Maybe you could send me the data you're trying to use so I can check on my version to see if it works?

I'm just using the same spreadsheet that you uploaded...no other data. Is that the problem perhaps?

[ryker]

	Quote:	TinGull
	I'm just using the same spreadsheet that you uploaded...no other data. Is that the problem perhaps?

Yes it is the problem. The spreadsheet can't fetch the data for you unless you have a bloomberg terminal. If you don't you need to input your data.
Also, if you have a realtime feed, you can have a realtime update of the spreadsheet (just need to export the data in the csv file every minute).

[TinGull]

Ok, I've exported data into 1 minute segments but the spreadsheet still isn't seeing the data.

[wow]

I propose somebody use the google spreadsheet experiment with up to date S&P futures MP and let members in here update volunteering at convenient times. This could help solve probelms quicker.

[dctrader80]

Can someone please explain to me how to use rykers excel file. I am having difficulting updating the data.