Four Percent Rule

I am currently using Excel 2002 but would like it to work if I were to upgrade to a later version.

The projecIt will be a one page spreadsheet with seven columns.

Column A: Format for Date (I will populate with the weekly reference index closing dates)

Column B: Format for Currency or a number with 2 decimal places if necessary to make formulas work. (I will populate with dollar value of reference index on the dates in column A)

Column C: Will display in % (or number if needed to make the formulas work) change in price from the previous week.

Column D will contain the results of the rule below:

A BUY signal will be generated when the dollar value weekly close of the reference index (value in column B) rises four percent or more from the previous weekly close of that index. A SELL/SHORT signal will be generated when the dollar value of the weekly close of the reference index falls four percent or more from the previous weekly close of that index.

SECOND RULE: If the rule generates a BUY signal and the previous signal was a BUY, no signal would be displayed. If the rule generates a SELL signal and the previous signal was a SELL no signal would be displayed.

*********

I started this project with the formula below and found it would work for all but the value -4%. So gave up and am asking an expert!

=IF(C3>=4%,"If out if the market, BUY", IF(C3<=-4%,"If in the market,

SELL/SHORT"))

********

Column E: Format for Currency (or a number with 2 decimal places if necessary to make formulas work). I will populate with weekly closing prices of any stock I am interested in, I will call it Alpha.

Column F: Will calculate the % change in the price of Alpha since the last signal.

**Because I will be shorting the market, the value of the % change between the SELL/SHORT signal and the BUY signal is reversed which means it would be positive if the BUY number is lower than the SELL number above and visa versa. Example, if I would sell short the stock at \$100.00 and then I Buy it at 75.00 I would have a \$25.00 profit because I was betting against the market. The reverse is true.

Column G: Format for Currency. Line one would be the value of an original investment. Each time a signal is generated and we calculate the gain/loss in Column F: this change would be applied the current value in Column G resulting in a running total value of the investment.

Beceriler: Excel

İşveren Hakkında:
( 1 değerlendirme ) The Villages, United States

Proje NO: #747063

Seçilen:

FinanceMike

Stock broker for 6 years. Can do this quickly and professionally.

1 gün içinde %selectedBids___i_sum_sub_4%%project_currencyDetails_sign_sub_5% USD
(1 Yorum)
1.4

Bu iş için 21 freelancer ortalamada \$75 teklif veriyor

frehmanpk

Respected Sir, Very easy task. Just send data and get work done. More details in PM. Kindest Regards.

in %bids___i_period_sub_35% gün içinde30%project_currencyDetails_sign_sub_37% %project_currencyDetails_code_sub_38%
(5 Değerlendirme)
2.5
shaildeogam

Hi, I am interested in this project and ready to do it now. Please see PMB. Regards!

in %bids___i_period_sub_35% gün içinde75%project_currencyDetails_sign_sub_37% %project_currencyDetails_code_sub_38%
(1 Yorum)
1.0
Mitshel

Can do this easily if can discuss detail of columns and where you want the comparison input to go if interested, please contact Mitch at 561-602-0090

1 gün içinde %bids___i_sum_sub_32%%project_currencyDetails_sign_sub_33% USD
(0 Değerlendirme)
0.0
Sure2005

We are able to do this project. Please discuss, have a great day.

in %bids___i_period_sub_35% gün içinde100%project_currencyDetails_sign_sub_37% %project_currencyDetails_code_sub_38%
(0 Değerlendirme)
0.0
ghareeb1

111111111111111111111111111111

in %bids___i_period_sub_35% gün içinde100%project_currencyDetails_sign_sub_37% %project_currencyDetails_code_sub_38%
(0 Değerlendirme)
0.0
Securefuturegrp

My bidding amount is \$70 (Negotiable) Initial Milestone % can be considered as "0". Turn Around Time - 3 Working days

in %bids___i_period_sub_35% gün içinde70%project_currencyDetails_sign_sub_37% %project_currencyDetails_code_sub_38%
(0 Değerlendirme)
0.0

Will do it in couple of hours.........

in %bids___i_period_sub_35% gün içinde75%project_currencyDetails_sign_sub_37% %project_currencyDetails_code_sub_38%
(0 Değerlendirme)
0.0
kalhusoru

I think I would be able to fulfill this project requirements. Thank you!

in %bids___i_period_sub_35% gün içinde50%project_currencyDetails_sign_sub_37% %project_currencyDetails_code_sub_38%
(0 Değerlendirme)
0.0
shanikamsd123

in %bids___i_period_sub_35% gün içinde30%project_currencyDetails_sign_sub_37% %project_currencyDetails_code_sub_38%
(0 Değerlendirme)
0.0
mohdrafionline

I can do it.

1 gün içinde %bids___i_sum_sub_32%%project_currencyDetails_sign_sub_33% USD
(0 Değerlendirme)
0.0
pushstart1

sir/ma'am i'm interested to this project. pls. check PM...

1 gün içinde %bids___i_sum_sub_32%%project_currencyDetails_sign_sub_33% USD
(0 Değerlendirme)
0.0
ProshedBarmon

Fear sir, I am expert in Excel. I can do it.......

in %bids___i_period_sub_35% gün içinde100%project_currencyDetails_sign_sub_37% %project_currencyDetails_code_sub_38%
(0 Değerlendirme)
0.0
aramae

Hello! i am confident to do this project. Please see my pm.. thank you!

in %bids___i_period_sub_35% gün içinde30%project_currencyDetails_sign_sub_37% %project_currencyDetails_code_sub_38%
(0 Değerlendirme)
0.0
maqsoodkhawaja

Sir I am excel epert. Please give me chace

1 gün içinde %bids___i_sum_sub_32%%project_currencyDetails_sign_sub_33% USD
(0 Değerlendirme)
0.0
mafiur

pls see my pm. thanks

in %bids___i_period_sub_35% gün içinde100%project_currencyDetails_sign_sub_37% %project_currencyDetails_code_sub_38%
(0 Değerlendirme)
0.0
myunicorn84

Hello! I couldn't believe when I read your posting. I have been looking for work at home projects and your ad was a breath of fresh air. I work in accounting / bookkeeping. Your project is my cup of tea. I would love t Daha Fazla

1 gün içinde %bids___i_sum_sub_32%%project_currencyDetails_sign_sub_33% USD
(0 Değerlendirme)
0.0

Sir I am ready to this sincerely. Pls see PM.

in %bids___i_period_sub_35% gün içinde200%project_currencyDetails_sign_sub_37% %project_currencyDetails_code_sub_38%
(0 Değerlendirme)
0.0
KiwiSri

Hi Sounds easy. This is the kind of projects I am familar at and love to take up. See my PM

in %bids___i_period_sub_35% gün içinde100%project_currencyDetails_sign_sub_37% %project_currencyDetails_code_sub_38%
(0 Değerlendirme)
0.0
BorisZlato

Hello I am a finance professional looking for additional income. My bid is low to attract positive feedback to get me started. Many Thanks

in %bids___i_period_sub_35% gün içinde30%project_currencyDetails_sign_sub_37% %project_currencyDetails_code_sub_38%
(0 Değerlendirme)
0.0
Kamrankhilji

I have shining computer skills of Data Entry, internet, Microsoft Excel, Microsoft Word, Web Searching etc. I have experience of working at Public Limited Company and National Citizens Registration Organisation. Kam Daha Fazla

in %bids___i_period_sub_35% gün içinde65%project_currencyDetails_sign_sub_37% %project_currencyDetails_code_sub_38%
(0 Değerlendirme)
0.0