Firehorse's trading spreadsheet | Page 2 | 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

  • #21
  • Aug 4, 2006 10:47am Aug 4, 2006 10:47am
Hi Snuffle,

Looks likes our posts got lost in the upgrade

Thanks for your testing. Let me know if you find any other bugs.

I'm reattaching the spreadsheet.

Many thanks
Alan
Attached File(s)
File Type: zip fh_fxcalc_060803.zip   31 KB | 666 downloads
  • #22
  • Dec 6, 2006 11:21pm Dec 6, 2006 11:21pm
Has the update function stopped working on this for anyone else?

It's still a great tool, but now when I update it shows zeros for the prices.
  • #23
  • Dec 8, 2006 10:35am Dec 8, 2006 10:35am
Hi Snuffle,

Yahoo changed their website layout!

I've updated the spreadsheet.

Let me know if you have any problems.

Best regards
Alan
Attached File(s)
File Type: zip fh_fxcalc_061208.zip   < 1 KB | 488 downloads
  • #24
  • Dec 8, 2006 1:19pm Dec 8, 2006 1:19pm
Quoting firehorse
Hi Snuffle,

Yahoo changed their website layout!

I've updated the spreadsheet.

Let me know if you have any problems.

Best regards
Alan
Thanks Alan.

It appears to be a blank file.

Previous attachment: fh_fxcalc_060803.zip (30.6 KB, 18 views)

Last attachment: fh_fxcalc_061208.zip (138 Bytes, 3 views)
  • #25
  • Dec 8, 2006 4:59pm Dec 8, 2006 4:59pm
Hi Snuffle,

Sorry about that. I don't know what happened. I zipped it using winrar and uploaded it. I double checked the file on my disk and it was empty

I've done the same thing again this time it's 34kb.

I've changed the name and uploaded it again.

Best regards
Alan
Attached File(s)
File Type: zip fh_fxcalc_061209.zip   33 KB | 623 downloads
  • #26
  • Dec 8, 2006 7:25pm Dec 8, 2006 7:25pm
Firehouse,

Can you reprogram it to get instant data? It would be a great add on. I will try to tweak it to metatrader. You can get a metatrader interface if you get the Metatrader Demo Account and just download their free software. Once you are logged on you can interface it with excel in real time.
Go to this link and it will explain the nuts and bolts:
http://www.4xlab.net/cs/forums/136/ShowPost.aspx
  • #27
  • Dec 9, 2006 12:40am Dec 9, 2006 12:40am
Hi,
Quoting thn5625
Can you reprogram it to get instant data?
I probably could if I spent enough time on it. But I don't require real time prices in a spreadsheet.

I use the spreadsheet to quickly calculate my entries sizes when entering a trade.

It also additional helps me work out with my 'locked' in profits if I'm entering further positions based on the locked in profits.

Best regards
Alan
  • #28
  • Dec 9, 2006 4:28pm Dec 9, 2006 4:28pm
Quoting firehorse
Hi,
I probably could if I spent enough time on it. But I don't require real time prices in a spreadsheet.

I use the spreadsheet to quickly calculate my entries sizes when entering a trade.

It also additional helps me work out with my 'locked' in profits if I'm entering further positions based on the locked in profits.

Best regards
Alan
Hi Alan,
I could probably take care of this, if you don't mind me mucking around in your code. I've looked at it already, and I think it would be really rather simple.

-john
  • #29
  • Dec 9, 2006 6:23pm Dec 9, 2006 6:23pm
Hi John
Quoting johne59
Hi Alan,
I could probably take care of this, if you don't mind me mucking around in your code. I've looked at it already, and I think it would be really rather simple.

-john
Sure. It's very simple code anyway Excel macros is not my strong point!

I would suggest having a second button something along to lines of "MT4 FX prices" so people have the option of getting it from off the web if they are not running MT4.

Best regards
Alan
  • #30
  • Dec 9, 2006 11:43pm Dec 9, 2006 11:43pm
Alan,
With your blessing, I have updated your spreadsheet to include current prices through MetaTrader terminal DDE server.

In order to function your MT client terminal MUST be up and running with the DDE Server enabled. The DDE Server option can be located under
Tools -> Options -> Server -> Enable DDE server.

The current Price will reflect bid/ask only after buy/sell is selected and then the "Get MT Prices" button is pressed. I wasn't going to spend a ton of time to make it update just by pressing the buy/sell button. By the time you fool with this spreadsheet the price will have changed anyway.

Happy pippin'
-john
Attached File(s)
File Type: zip fh_fxcalc_061209a.zip   38 KB | 830 downloads
  • #31
  • Edited 9:10am Dec 10, 2006 8:35am | Edited 9:10am
Hey Allan


I dont know but i have some problems by refreshing data from yahoo ? is it only me ? there has the problem by the way great work :-) the problem seems to be when refreshing it mess up with the comma seperators on the yahoo sheet

revoke
  • #32
  • Dec 10, 2006 4:20pm Dec 10, 2006 4:20pm
Hi,
Quoting revoke
I dont know but i have some problems by refreshing data from yahoo ? is it only me ? there has the problem by the way great work :-) the problem seems to be when refreshing it mess up with the comma seperators on the yahoo sheet
I don't have any problems updating from yahoo.

Has it ever worked properly?
Which country settings do you have for your computer, is it period "." for decimal point, and comma "," for thousand separators? (just a guess for this one)

Anyone else having problems using yahoo?

Best regards
Alan
  • #33
  • Dec 11, 2006 12:53pm Dec 11, 2006 12:53pm
Thanks firehorse

ill try and check my settings as it must be there the problem is.Are u good for excell sheets? as i did se once a sheet for correlation analysis for excel ( currency strengh) against others


revoke
  • #34
  • Dec 11, 2006 2:06pm Dec 11, 2006 2:06pm
It is updating now

revoke
  • #35
  • Dec 11, 2006 2:10pm Dec 11, 2006 2:10pm
Quoting revoke
It is updating now

revoke
Are the MT4 current prices working alright for you?

-john
  • #36
  • Dec 11, 2006 2:49pm Dec 11, 2006 2:49pm
sorry i am not using metatrader

revoke
  • #37
  • Dec 11, 2006 2:56pm Dec 11, 2006 2:56pm
Quoting johne59
Are the MT4 current prices working alright for you?

-john
Both Yahoo and MT4 are working. Thanks guys.

I did notice one MT4 issue. If you look in the eurjpy price field the formula ends with "EURJPYD". That appears to be a typo causing it to show "N\A" instead of a price.
  • #38
  • Dec 11, 2006 3:48pm Dec 11, 2006 3:48pm
Quoting johne59
Are the MT4 current prices working alright for you?

-john
Yes! It works, it's great . Thank you for the good work!
  • #39
  • Dec 11, 2006 3:52pm Dec 11, 2006 3:52pm
Quoting Snuffleupagus
Both Yahoo and MT4 are working. Thanks guys.

I did notice one MT4 issue. If you look in the eurjpy price field the formula ends with "EURJPYD". That appears to be a typo causing it to show "N\A" instead of a price.
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.
  • #40
  • Dec 11, 2006 5:57pm Dec 11, 2006 5:57pm
Hi,
Quoting revoke
as i did se once a sheet for correlation analysis for excel ( currency strengh) against others
A search for correlation excel showed up this thread

http://www.forexfactory.com/forexfor...relation+excel

Look for posts by Isotonic

Best regards
Alan
0 traders viewing now