Firehorse's trading spreadsheet | Page 3 | Forex Factory

Options

Go to
Permalinks
Print Thread

Similar Threads

Forex Trading Journal Spreadsheet 14 replies

Forex Trading Journal spreadsheet 16 replies

Help with spreadsheet trading journal 2 replies

VWB - Average Range Spreadsheet 6 replies

Forex data spreadsheet 11 replies

Attachments: Firehorse's trading spreadsheet
Exit Attachments

Firehorse's trading spreadsheet

  • #41
  • Dec 11, 2006 8:29pm Dec 11, 2006 8:29pm
Quoting A1Cruiser
It can be easily fixed in Excel using Tools --> Macro --> Visual Basic Editor. You should delete the inproper "D"s two cases from the end of EURJPY.

That worked. Thanks.
  • #42
  • Dec 1, 2007 7:37am Dec 1, 2007 7:37am
Hi all


What needs t be done in order to use this spreadsheet with a GBP account? Is it ready to use as is?



thanks

FXP
  • #43
  • Dec 1, 2007 7:56am Dec 1, 2007 7:56am
Nice piece of art.....
  • #44
  • Dec 23, 2007 8:08pm Dec 23, 2007 8:08pm
Hi FXP,
Quoting fxprocessor
Hi all

What needs t be done in order to use this spreadsheet with a GBP account? Is it ready to use as is?

thanks

FXP
Sorry for the late reply, I've been busy elsewhere

The spreadsheet has been setup for use with USD accounts.

I have to say that I learnt a lot from setting up the spreadsheet

Feel free to look at the existing formulas to see how to convert it to gbp

Best regards
Alan
  • #45
  • Mar 5, 2010 11:28am Mar 5, 2010 11:28am
Bump because I've just found this and it's brilliant!
"I made all my money by selling too soon"
  • #46
  • Last Post: Edited 9:52pm Jan 6, 2019 12:51pm | Edited 9:52pm
Hi firehorse and johne56,

Firehorse thanks for the spreadsheet ad johne56 thanks for the Mt4 update. However, I think there is a bug in it. I tried to find the cause, but I gave up on it. In the Current Price section, EURJPY cell displays N/A instead of price. The code for EURJPY is "=MT4|BID!EURJPYD", which I think is wrong. Shouldn't it be =MT4|BID!EURJPY? I tried to delete the "D" at the end of EURJPY, but the formula always rewrites itself and goes back to =MT4|BID!EURJPYD. Also in K9 cell the "Now Lot" cell displays #Value!. Error checking K9 says that there is an error in this cell. Can you fix this when you have time and when you are in mood? Thanks.

I have another question. Is there a simple way to add more currencies to the column?

thanks in advance,

attim
0 traders viewing now