how can I import current pip value of USDJPY into GoogleDocs Spreadsheet? | Forex Factory

Options

Permalinks
Print Thread

Similar Threads

Pip (Lot) Value Calculation (Converter) Spreadsheet 8 replies

Correlation Table - Importing OHLC Data for all pairs into a spreadsheet. 3 replies

How to import MT4 indicator output to spreadsheet? 1 reply

Spreadsheet to calculate Pip P/L from Duka's Position Report 8 replies

Need help with importing prices from MT4 into Excel spreadsheet 1 reply

how can I import current pip value of USDJPY into GoogleDocs Spreadsheet?

  • #1
  • First Post: Nov 8, 2007 6:49am Nov 8, 2007 6:49am
Hi,

anyone know of a good source on the internet for current prices that I can import into Google Docs Spreadsheet?

here is a list of formats Google Docs supports:

http://documents.google.com/support/...er=75507&hl=en

rss / ATOM, xml, html pages and csv or txt files I think is the list.

I want to get the pip value of USDJPY (for example) into a cell.

any help appreciated, thanks!
  • #2
  • Nov 8, 2007 9:11am Nov 8, 2007 9:11am
I can send you data in a .txt file if you want.
  • #3
  • Nov 8, 2007 9:41am Nov 8, 2007 9:41am
phil, thanks for the offer... but I was thinking there should be some kind of info constantly updated and parseable provided by some broker or FX news provider or something somewhere on the web... if not in any easy format, then I guess GoogleDocs lets you parse an HTML table (from what it is saying)

there is even a GoogleFinance() function but it didn't work with forex data... stocks no problem though.
  • #4
  • Nov 8, 2007 9:43am Nov 8, 2007 9:43am
Quoting ycomp
phil, thanks for the offer... but I was thinking there should be some kind of info constantly updated and parseable... if not in any easy format, then I guess GoogleDocs lets you parse an HTML table (from what it is saying)

there is even a GoogleFinance() function but it didn't work with forex data... stocks no problem though.
Why couldn't you set up a DDE from a broker or even a MT4 server to your spread sheet. Does It the google software support a DDE? Excel does as does open office and lotus.
  • #5
  • Nov 8, 2007 10:02am Nov 8, 2007 10:02am
Quoting smjones
Why couldn't you set up a DDE from a broker or even a MT4 server to your spread sheet. Does It the google software support a DDE? Excel does as does open office and lotus.
don't think it supports DDE cause it's web based.
  • #6
  • Nov 8, 2007 11:54am Nov 8, 2007 11:54am
found this RSS source but there is way too much info there... and it is 20 min delayed.

http://www.currencysource.com/rss_cu...angerates.html

anyone know of anything better?
  • #7
  • Nov 8, 2007 3:33pm Nov 8, 2007 3:33pm
Quoting ycomp
found this RSS source but there is way too much info there... and it is 20 min delayed.

http://www.currencysource.com/rss_cu...angerates.html

anyone know of anything better?
Sorry fot the OffTopc - ycomp I can't send you PM (not enough posts) so pls try sending me e-mail through the site (I've enabled the option now).

Thank you,

Alex
  • #8
  • Nov 9, 2007 8:34am Nov 9, 2007 8:34am
Google Spreadsheets will upload data from Duksacopy if you save it down with a comma delimiter (be sure to select the correct one). I don't want to post the link here as I'm not sure what the policy is for that, it might be a competing website. If you google Duksacopy Data you should be able to find it.

Good Luck!
Trade Small. Be Patient. Learn to Survive.
  • #9
  • Last Post: Nov 9, 2007 11:27am Nov 9, 2007 11:27am
Quoting FXAnalytics
Google Spreadsheets will upload data from Duksacopy if you save it down with a comma delimiter (be sure to select the correct one). I don't want to post the link here as I'm not sure what the policy is for that, it might be a competing website. If you google Duksacopy Data you should be able to find it.

Good Luck!
thanks! will do
0 traders viewing now