Home
>
Feature Requests
>
Topic
Currency Exchange Rates
Posted by ameridan
|
Currency Exchange Rates February 21, 2013 11:46PM | Registered: 11 years ago Posts: 20 |
Just throwing another idea out there to expand PalOMoney's usefulness:
Being able to update Currency Exchange Rates like Money used to do. This comes in very handy when buying World Currency CDs from Everbank as an example. I used to have some in Australian Dollars and Canadian Dollars.
Edited 1 time(s). Last edit at 02/21/2013 11:55PM by ameridan.
Being able to update Currency Exchange Rates like Money used to do. This comes in very handy when buying World Currency CDs from Everbank as an example. I used to have some in Australian Dollars and Canadian Dollars.
Edited 1 time(s). Last edit at 02/21/2013 11:55PM by ameridan.
|
Re: Currency Exchange Rates February 22, 2013 06:12PM | Admin Registered: 7 years ago Posts: 164 |
Examining the currency exchange rate tables in Money found that the data there contained single entries for currency pairs. It seems that the table's primary key is the currency pair plus a Boolean "hist" flag. This implies that the table can store only 2 dates worth of historical exchange rate data.
It seems a simple matter to update the exchange rate table for 2 dates, one for a "current" value, and the other for a "historical" date. The dates don't have to be the same for each currency pair.
There are lots of web APIs for getting real time and a few for historical data. If you are ambitious, you might write some python scripts to download and output a .csv file with "From, To, Date, Rate, HistFlag." data, which PalOMoney or MoneyPal could import. "Histflag" would specify if a History or a Non-History record were being updated. Or, perhaps the "hist" flag business could be specified for the entire download in some other way.
But... How can Money's graphs of net worth over time be accurate if the price for a security is stored in the native currency, but the exchange rate is not applied to each date? It seems something is missing here.
Although the database table schema could be modified to change the primary key to FromCurrency-ToCurrency-Date, this would most likely break Money's use of the table.
It seems a simple matter to update the exchange rate table for 2 dates, one for a "current" value, and the other for a "historical" date. The dates don't have to be the same for each currency pair.
There are lots of web APIs for getting real time and a few for historical data. If you are ambitious, you might write some python scripts to download and output a .csv file with "From, To, Date, Rate, HistFlag." data, which PalOMoney or MoneyPal could import. "Histflag" would specify if a History or a Non-History record were being updated. Or, perhaps the "hist" flag business could be specified for the entire download in some other way.
But... How can Money's graphs of net worth over time be accurate if the price for a security is stored in the native currency, but the exchange rate is not applied to each date? It seems something is missing here.
Although the database table schema could be modified to change the primary key to FromCurrency-ToCurrency-Date, this would most likely break Money's use of the table.
|
Re: Currency Exchange Rates February 23, 2013 06:02PM | Registered: 11 years ago Posts: 20 |
OK, I may not be the best person to ask regarding Currency Exchange, but if I click on Manual Update prices for some 2008 3-month CDs in Aussie dollars, all of the buy & sell prices are listed in AUD$ (Australian dollars) just like they would be for stocks, but I don't see any MSN online updates for currency exchange. From the Help files...
Edited 1 time(s). Last edit at 02/23/2013 06:03PM by ameridan.
which seems to collaborate with your findings (no historical data). Perhaps you want to await another user's request for this feature that actually needs it.Quote
Convert a transaction to or from a foreign currency
If you enter a transaction in a foreign currency, Money can convert the transaction amount into another currency. For example, if you reside in the United States and make a purchase in Canada, you can convert the cost of the purchase into U.S. dollars.
--------------------------------------------------------------------------------
Note: To perform this advanced task, you must be using the Advanced Account Register. To find out which register you're using, look for the Essential Register or Advanced Register label in the upper-right corner of the account register.
Click Banking, and then click Account List.
Click the name of an account.
Click New, and then enter payee (A person or business to whom you write a check or make some other kind of payment.) and date information.
In the Amount box, enter the amount of foreign currency you spent or received.
Right-click the Amount box, and then click Currency Converter.
In the Transaction currency box, select the currency you're converting from.
To view the current exchange rate, click one of the options under Display exchange rate as.
In the Exchange rate box, you can:
Use the current exchange rate as displayed.
- or-
Enter the exchange rate used at the time you made the purchase or exchanged money.
Click OK, and then click Enter.
Notes
You can also convert the currency in an existing transaction. To do so, select the transaction, click Edit, and then follow steps 5 through 9 above.
To convert the currency of a downloaded transaction, right-click the amount, and then click Currency Converter.
Edited 1 time(s). Last edit at 02/23/2013 06:03PM by ameridan.
Sorry, only registered users may post in this forum.