my $insertMACDDataSQL = "INSERT INTO `%s` (date, stockId, macdSignal, macd, macdHistogram, macdIsAsOfClose) VALUES ('%s', %s, %s, %s, %s, %s)
ON DUPLICATE KEY UPDATE macdSignal = VALUES(macdSignal), macd = VALUES(macd), macdHistogram = VALUES(macdHistogram), macdIsAsOfClose = VALUES(macdIsAsOfClose);";

...


my $sql = sprintf($insertMACDDataSQL, $stock, $MACDDate, $stockId, $MACDSignal, $MACD, $MACDHist, $MACDIsAsOfClose);
print $sql."\n";
my $result = $dbHandle->do($sql);
print Data::Dumper::Dumper($result)."\n";