New posts

Reply to thread

Message

Not sure what you mean by dirty and inconsistent - it is just raw data in a csv format which is as universal a format we can offer and which should be readable by most programs. We are currently in the process of redoing our website and I'll be adding in some online charts for the data and if we can automate the file creation, then save into some other formats.

Our FX rate did crash in the GFC, but so did the USD silver price. Here are two data points with aprox high and low points for the aussie around that time:

Date USD Silver FX Rate AUD Silver
16/07/08 19.15 0.9786 19.57
21/11/08 9.36 0.6180 15.16

Basically the FX drop was not enough to make up for the USD silver price drop. Because AUD silver price is derived via dividing, the maths of it mean the percentages do not work as you described. For example, in the table above the aussie drops 36.8% but lets assume that the USD silver stayed at $19.15. In that case the AUD silver price would have went up to (19.15 / 0.6180) = $30.99, which is an increase of 58.3%.

<blockquote data-quote="Bron Suchecki" data-source="post: 732917" data-attributes="member: 21302">Not sure what you mean by dirty and inconsistent - it is just raw data in a csv format which is as universal a format we can offer and which should be readable by most programs. We are currently in the process of redoing our website and I&#039;ll be adding in some online charts for the data and if we can automate the file creation, then save into some other formats.Our FX rate did crash in the GFC, but so did the USD silver price. Here are two data points with aprox high and low points for the aussie around that time:<table style='width: 100%'><tr><td>Date</td><td>USD Silver</td><td>FX Rate</td><td>AUD Silver</td></tr><tr><td>16/07/08</td><td>19.15</td><td>0.9786</td><td>19.57</td></tr><tr><td>21/11/08</td><td>9.36</td><td>0.6180</td><td>15.16</td></tr></table>Basically the FX drop was not enough to make up for the USD silver price drop. Because AUD silver price is derived via dividing, the maths of it mean the percentages do not work as you described. For example, in the table above the aussie drops 36.8% but lets assume that the USD silver stayed at $19.15. In that case the AUD silver price would have went up to (19.15 / 0.6180) = $30.99, which is an increase of 58.3%.</blockquote>

[QUOTE="Bron Suchecki, post: 732917, member: 21302"] Not sure what you mean by dirty and inconsistent - it is just raw data in a csv format which is as universal a format we can offer and which should be readable by most programs. We are currently in the process of redoing our website and I'll be adding in some online charts for the data and if we can automate the file creation, then save into some other formats. Our FX rate did crash in the GFC, but so did the USD silver price. Here are two data points with aprox high and low points for the aussie around that time: [table="width: 500"] [tr] [td]Date[/td] [td]USD Silver[/td] [td]FX Rate[/td] [td]AUD Silver[/td] [/tr] [tr] [td]16/07/08[/td] [td]19.15[/td] [td]0.9786[/td] [td]19.57[/td] [/tr] [tr] [td]21/11/08[/td] [td]9.36[/td] [td]0.6180[/td] [td]15.16[/td] [/tr] [/table] Basically the FX drop was not enough to make up for the USD silver price drop. Because AUD silver price is derived via dividing, the maths of it mean the percentages do not work as you described. For example, in the table above the aussie drops 36.8% but lets assume that the USD silver stayed at $19.15. In that case the AUD silver price would have went up to (19.15 / 0.6180) = $30.99, which is an increase of 58.3%. [/QUOTE]

Verification