Search found 12 matches
- 24 Feb 2021, 22:45
- Forum: Ask for Help (v1)
- Topic: Spreadsheet to arrays into an array Topic is solved
- Replies: 4
- Views: 656
Re: Spreadsheet to arrays into an array Topic is solved
I didn't try to address the rest of what your script is doing, but you can use this function to read your CSV file contents into an array that is keyed on the header name and the row number, starting with the row after the header row as 1. So in your example file, MyData.high.4 (or MyData["high"][4...
- 24 Feb 2021, 20:25
- Forum: Ask for Help (v1)
- Topic: Spreadsheet to arrays into an array Topic is solved
- Replies: 4
- Views: 656
Re: Spreadsheet to arrays into an array Topic is solved
Chunjee wrote: ↑24 Feb 2021, 20:08What attachment?
[lib] CSV - AutoHotkey library for working with CSV Files might be useful.
![Image](https://i.ibb.co/LzSYGvw/Screenshot-1140.png)
This forum keeps on keeps on breaking the link and won't let me attach the .csv file for some reason
- 24 Feb 2021, 18:24
- Forum: Ask for Help (v1)
- Topic: Cryptocurency web scrapping in Chrome
- Replies: 2
- Views: 972
Re: Cryptocurency web scrapping in Chrome
Hello, Could someone advice where I could find info how to connect to Chrome with AHK? I tried to web scrapping with IE, but it seems that IE cant handle crypto curreny page features and do not show latest date or other coins. I want to do some analysis and have practice with web scrapping. Thank y...
- 24 Feb 2021, 18:23
- Forum: Ask for Help (v1)
- Topic: Spreadsheet to arrays into an array Topic is solved
- Replies: 4
- Views: 656
Spreadsheet to arrays into an array Topic is solved
I need some help! I'm trying to have a script create an array with several arrays generated with each having the name of the first cell in each colum in an .csv file. The script would read the first row of the file and create an array for each of the cells in the first row, then would .Push() into t...
- 29 Dec 2020, 03:47
- Forum: Ask for Help (v1)
- Topic: Multi Dementional Array to String Topic is solved
- Replies: 3
- Views: 257
Multi Dementional Array to String Topic is solved
Multi arrays in Array to string How can I turn an array into a string were there are some elements in the array that have arrays and maybe some arrays in there too? So far I made this, but its limited to only two layers of arrays cutter(array) { Loop, % array.Count() { if !(array[A_Index].Count()) r...
- 26 Dec 2020, 04:11
- Forum: Ask for Help (v1)
- Topic: lowest number in array that's not less than 5 Topic is solved
- Replies: 7
- Views: 259
lowest number in array that's not less than 5 Topic is solved
How can I get the lowest number in an array thats no less than 5?
Example:
Example:
Code: Select all
array := [9,2,6,4,4,7,2,5.9]
Msgbox, % min(array*) ;would return 5.9
- 01 Dec 2020, 16:27
- Forum: Ask for Help (v1)
- Topic: Help with function Topic is solved
- Replies: 2
- Views: 274
Help with function Topic is solved
Hey there! Could someone help me turn this spreadsheet into a function returning the last column? Each row is supposed to represent each execution of the order(close, long, qty) Function, but im stuck. So far this is the code I managed to make but I'm only half way to getting the final column shown ...
- 30 Nov 2020, 22:48
- Forum: Ask for Help (v1)
- Topic: Hardware for data crunching and large arrays
- Replies: 2
- Views: 311
Hardware for data crunching and large arrays
I’m looking to up grade my hardware specifically for running autohotkey scripts. These scripts have to calculate many averages and other functions on every element of every array, but its taking ages to crunch the results. There’s a 3 dimensional cube testing combinations and each of those combinati...
- 27 Nov 2020, 03:52
- Forum: Ask for Help (v1)
- Topic: Shrink code
- Replies: 6
- Views: 397
Re: Shrink code
Hmm, theres a strange issue with output := [] For i, varname In ["close", "orderSize", "orderValue", "long", "reversal" , "orderSum", "valueOfOrder", "valueOfSum", "avgPrice", "change", "pyramids" , "tradeProfit", "capitalProfit", "cumulativeProfit", "cumulativePercentage"] { last%varname% := %varn...
- 26 Nov 2020, 22:22
- Forum: Ask for Help (v1)
- Topic: Shrink code
- Replies: 6
- Views: 397
Re: Shrink code
A bit shorter, results should be the same. I notice that output var stores same values as all those last* vars. Maybe there is a way to get rid of them and achieve even cleaner variant. order(close, long, qty, totalCapital) { orderSize := (long == false) ? -qty : qty orderValue := totalCapital / cl...
- 26 Nov 2020, 01:56
- Forum: Ask for Help (v1)
- Topic: Shrink code
- Replies: 6
- Views: 397
Shrink code
Is there a clean organized way I could shrink this snippet? global lastClose := "na" global lastOrderSize := "na" global lastOrderValue := "na" global lastLong := "na" global lastReversal := "na" global lastOrderSum := "na" global lastValueOfOrder := "na" global lastValueOfSum := "na" global lastAvg...
- 17 Nov 2020, 17:45
- Forum: Ask for Help (v1)
- Topic: Moving Average of a Moving Average Of an Array Topic is solved
- Replies: 1
- Views: 179
Moving Average of a Moving Average Of an Array Topic is solved
I've been scratching my head on this for a while, and haven't found out how to have a moving average of a moving average of an array Example: array_source := [1,2,3,4,5,6,7,8,9,10,11,12,13,14,15] first_average := moving_average(array_source, 2) last_average := moving_average(first_average, 3) arrayS...