Buy, Do Up and Sell Calculator

Instead of having to pull up the calculator off the start menu then transfer
that data to excel, it would be great if we could have a way to calculate
within the cell we want the data.

----------------
This post is a suggestion for Microsoft, and Microsoft responds to the
suggestions with the most votes. To vote for this suggestion, click the "I
Agree" button in the message pane. If you do not see the button, follow this
link to open the suggestion in the Microsoft Web-based Newsreader and then
click "I Agree" in the message pane.

http://www.microsoft.com/office/comm...el.programming

Howdy;

I apologize if the board discourages talking about such things; and please delete this post if this is the case, but:

Does anyone have any experience selling spreadsheets/excel utilities? I've made something I think there might be a niche market for; and was wondering if there was any way to ensure that only people who have registered can use the software?

How does other software prevent unwanted piracy?

Are there any copyright issues from using excel, or solver, or any other part of excel bundled with office?

thanks in advance

Hey,
I have a macro which scans data in column A and chucks out either "BUY" in B column, "SELL" in C column, or leaves both empty in each row. I would like to write a small macro that will total up the trades to give out a profit/loss. To do so, as it scans down, it has to buy at only the first BUY command, then sell at the next SELL command.
I was told that using While loops might be able to do it, but I have been stumped as to how so far.
Any help would be much appreciated.
SpeedoJimmy

I have a macro that pulls up specific pictures copys and pastes it into a specific sheet. I have to do something like

ActiveSheets.Pictures("Floor10").Select

This would pull up the pictures I named "Floor10" but I want to be able to type in a cell "Floor10" and then have the macro use that as what it should pull up...something like

ActiveSheets.Pictures("A1").Select

Of course this isn't working for me...does anyone know how to do this?

Mayve set A1 as a picture name somehow?

Hello!,

Some times ago I have designed a VBA application for certain Irish company which optimize a steel procurement - some screenshots you can find here http://excelekspert.pl/moje-programy...wie-stali.html. Now I would like to sell this one via internet. Can you tell me where I can run announcement? I`m looking for a place where IT buyers are meeting IT sellers and vice versa

I`m very grateful for your help

Kind regards,
Mariusz Jankowski

Hey,
I have a macro which scans data in column A and chucks out either "BUY" in B column, "SELL" in C column, or leaves both empty in each row. I would like to write a small macro that will total up the trades to give out a profit/loss. To do so, as it scans down, it has to buy at only the first BUY command, then sell at the next SELL command.
I was told that using While loops might be able to do it, but I have been stumped as to how so far.
Any help would be much appreciated.
SpeedoJimmy

Hi everyone,

I have one question regarding the cost of buying stock.

Please see the link for example in my worksheet.

If I buy 100 stocks with price p1 at time t1, then sell 50 stocks. Then I just have got 50 stocks left. Now I buy another 100 stocks with price p2 at time t2, which means I get 150 stocks in my portfolio. Now, I try to sell 70 stocks, which include 50 stocks from buy time t1 and 20 stocks from buy time t2. Consequently I have to pay 50*p1 + 20*p2.

Let's take stock SNE in my worksheet for example.

I bought 100 stocks SNE with price of 650, and sell 20, then 30, then 40, and I got 10 stocks left (which is represented in H23). Now I bought 20 more stocks with price of 599. And I sold 20, which included 10 stocks with price of 650 and 10 stocks with price of 599. Hence, I had to pay 10*650+10*599=12490 as in cell H25 which represents the cost I have to pay.

Actually I hard-coded column H. Does anyone know the formula for column H? Requirements a Regarding a stock (for example SNE): if G25=buy, then I25=D25*E25
else { if the remaining stocks from the first buy is greater than D25, I25=D25*(price of the the first buy time)

else I25= Remaining stocks * price of the first buy + (D25-remaining stocks) * price of second buy
}
The work should be done in generally and I have no idea to such a complicated problem. I would very appreciate your help at this moment.

HI all, first time here on these forums, wish I had found them before now though...

Any way I need to automatically fill a cell according to what I have filled in another cell, for example: -

Cell A1 could contain any of the following

255.255.255.252
255.255.255.248
255.255.255.240
255.255.255.224
255.255.255.192
255.255.255.128
255.255.255.0

Then in another cell A2 I would like it to add the following automatically

0.0.0.3
0.0.0.7
0.0.0.15
0.0.0.31
0.0.0.63
0.0.0.127
0.0.0.255

The 255's below is what I would type A1 and the "=" would automatically be place in A2

255.255.255.252 = 0.0.0.3
255.255.255.248 = 0.0.0.7
255.255.255.240 = 0.0.0.15
255.255.255.224 = 0.0.0.31
255.255.255.192 = 0.0.0.63
255.255.255.128 = 0.0.0.127
255.255.255.0 = 0.0.0.255

I hope you understand what I trying to explain here and can help me sort out the formula

Cheers all

Chet

I have read that macros created from Self Cirt will not work on another computer. I created a spreadsheet that I feel is unique and quite useful but it uses a lot of macros. I came across bitbuffet.com where you can upload and sell your sheets, but can I sell them with Macros?

Hi,

I have a trading system that generates a buy price in column AE and a sell price in column AF starting at row 8 for both columns. The first values in row 8 for either column AE or AF could be a buy price, sell price or a zero.

The output will go in column AG starting also at row 8. If there is no trade, the output should be N/A.

The number of rows in columns AE and AF is variable. Currently, the data fills rows up to row 1000. The formula should ignore rows that are blank. ("")

An example of the inputs and output is shown below:

Code:

AE	AF	AG
Buy	Sell	Signal
0	0	N/A
0	0	N/A
0	0	N/A
0	8.4	Sell
0	0	Sell
0	0	Sell
0	0	Sell
0	0	Sell
0	0	Sell
0	0	Sell
0	0	Sell
0	0	Sell
6.7	0	Buy
0	0	Buy
0	0	Buy
0	0	Buy
0	0	Buy
0	0	Buy
0	0	Buy
0	0	Buy
0	9.2	Sell
0	0	Sell
0	0	Sell
0	0	Sell
0	0	Sell
7.7	0	Buy
0	0	Buy
0	0	Buy
0	0	Buy
0	0	Buy

Could anyone in the Forum help with a cell formula to do this?

Thanks,

Art