Hi,
I have developed over 5 years a program in xp for trading on the stock market for novices. It is in 5 modules. module 1 predicts a purchase price for any stock. Module 2 completes a financial analysis. Module 3 provides a financial report. Module 4 advises how many shares to purchase. Module 5 produces a portfolio. Module 6 provides an annual report for taxation. I have had an inquiry to purchase the program but to forward it first. Is there any way that I can insert a formula that will corrupt the program within a given period if this is a scam?
I would like to record details of my stock/share trading. Showing WHAT I did
and WHY I did it, and ranking the results in terms of their success
(profitability)
I'm trying to manipulate a trading system that was created by my old boss. He has multiple tabs of the same trading system for the different portfolios, but I want to establish just 1 tab where you can switch between the portfolios in one swift click.
I know you can create combo boxes or by simply having all information link up to a cell that holds Portfolio (A, B, C, etc...) that it would work. However, there is one bit of information that is still hand entered, which is it's ID or properly called, CUSIP. I need to find a method to find the CUSIP (on another tab) and pull it in the right place.
It seems like a simple VLOOKUP, but I have many different funds for each portfolio and many times the same fund used in multiple portfolios. I need the CUSIP cell's to give me the values of the respective portfolio so when I click portfolio A I will get all the funds CUSIPS in their proper position.
I'm sorry I can't give screen shots as my work does not allow me to download any programs on here.
If anybody can help me with this dillemma I would greatly appreciate it.
Here is the excel sheet that goes along with the system. Tell me what you think of it on my other thread. Please feel free to ask questions.
I want to figure out how to make this trading system work, but my excel knowledge is very limited. I am sure this mechanical system will help a lot of people out there too.
Lets assume a price, say 500. We will call this the base price as this system is expected to give trade signals for volatile stocks. Lets say it either moves up or down, being volatile. Now we will say it should give a long signal if the Price= Base+10 or give a SHORT signal if the Price=Base-10. So signal is BUY at 510 Or Sell short at 490, with stoploss= base price.
Now this is simple but the problem for me begins when trying to put a trailing stoploss for maximum gains. Lets say the action was Buy since the price went to 510. Now the intial stoploss as mentioned above would be 500. But when the price continues to rise the stoploss must be 2 points behind and must stay at that if the price falls below. Let me explain. Say 510 became 512, so stoploss would be 510. Now price became 515 stoploss =513. But now the price fell to 514 from 515 , then the stoploss should hold at 513 of the previous value, not fall to 514-2 = 512. And if it becomes 513 it should give an action to sell stocks (square off).
Now this does not have to trigger any softwares or anything as such. Only one cell in the sheet must give commands to buy or sell or square off when stoploss triggers. The same applies for a trade action to short at 490, with initial stoploss 500. Say it reduces further, the stoploss will trail by 2 points till the lowest, eg say price=475 stoploss would be 473 but if it starts to rise then the stoploss value must hold at 473 and square off the position at 473. Say it did not reach 473 and started falling again from 474 then the trailing stoploss would continue to have maximum gains.
If possible maybe we could have the same solution running with 2 or 3 configurations maybe like stoploss trail of 5 points instead of 2 and maybe say base+20 instead of base+10.
I am not sure if it can be done. I am sure this method will be helpful to a lot of people who have their eyes on volatile stocks but want to keep fear, greed and any other emotions out of the equation. And I am sure that this will work, only need to test out to see the best numbers for different stocks.
One more thing that would be great, is a column or such which specifies how many trades have been actioned say on a day of trading. Please note that this is only paper trading to see if trades hit can offset my brokerages and to see what is the success rate of trades triggered.
I thank everyone who have read this question and sincerely thank and appreciate any responses in this regard.
I have a portfolio of shares stored in an Excel Workbook called Super 2 Etrade Contract Layout - the worksheet is called Super2 Holdings.
I need a macro to help me work out the average cost of each share held.
The Stock Codes (in Alpha order) are in Column C starting at C4.
The Quanitity per trade is is in Column F starting at F4.
The Total Cost per trade is in K starting at K4
I need to accumulate the Total Quantity per Stock and Total Cost per Stock into Column N & O respectively on the row of the last entry for the Stock - then divide that Total Cost by Total Quantity and put the result into Column P of the last entry for that stock.
Then move onto the next code and continue the calcluation until until there are no entries in Column C (ie the Stock Code in Column C is blank)
Hi all. Whenever i open my excel application, i am always prompted low system
resource and have to exit the application. However all my other office
applications like word, access work fine when i open them. I face similar
problems before and i reinstall excel to solve the problem. Is there a better
solution which can solve this problem once and for all? Thks in advance
I am building an experiment for trading here is the idea.
It came to me 3am so it's still quite raw the idea is to look at the historical data you can either have a Long or Short so we look back in history and from the open look either side for a 50 point price if there is and the occurrence is very high i.e. 90% of the time then add a point to the 50 pip so the system then look for 51 pip either side of the open continue until the occurrence hits our pre set Percentage once that is hit then see which has the higher probability of hitting that target either Long or Short.
I don't know how to seperate the Long and Short calculation as i will be adding more daily stats.
I have been attempting the formular for the Probability but i'm no good at this. Also I have not even attempted to do the target and adding of the point. I need to buy some books on Excel to help improve my lack of skills and hopefully give something back.
Any help would be great.
Regards
Kiwi
I have dynamic data that is automatically updated by a live feed. It updates cells m3:m32.
I currently have a code that plays a sound whenever a value in any of the cells is greater than a certain threshold and another code that plays when any of the cells goes below a certain threshold.
The problem is the sound continues to play each time the live feed is updated and the cell condition is correct.
I want the sound to play once for example when a cell value first goes less than 4, but then dont play again if it continues to be under 4. However, if a new cells value goes to less than 4, I want the sound to play.
The problem at the moment is my code limits the sound to play once but it applies to the total cell range not the individual cells so if a 2nd cell's value drops below 4 it wont play.
