![]() I may be unnecessarily complicating my life, but I need to be able to compare the cost of various widgets bought over multiple years, with multiple currencies and at multiple item prices. Will get back to this forum following testingFirst, thanks for the feedback and questions, they help me think through what I am trying to accomplish. I guess I am expecting too much from an off the shelf financial tracking program. And since I have perhaps 20 foreign currency transactions on any given day, I have to somehow remember the rate for each of those transactions. and can be duplicated on a year over year basis for comparison purposes. Very cludgie, but produces an accurate charge rate. So my work around, for now, is to use the historical rate table and to use the rate changes to plug against an extracted Excel file in raw currency amounts.įor example I may have 100 Euro transactions in a year (actually 3,000) and I can gather the data in Quicken under Euro currency accounts, then when I need to do a Can $ charge out, I extract all the Euro account numbers to Excel, refer to the historical exchange rate and apply that to each transaction in Excel. Unfortunately Quicken calculates the cost of a currency based on one rate applying to all transactions.Īnd the historical rate table does help in that it remembers a single rate of a given day, but I have not seen a way to calculate an annual comparison of cost of goods from within Quicken. ![]() Will get back to this forum following testingThanks for the suggestions, and it helps in a general sense, but not specific to individual transactions. ![]() Your comment about the historical exchange rate list is helpful and I will go back and test based on this table. ![]()
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |